I have data in multiple excel sheets. How do I import only certain columns only and plot the data.

I have multiple excel files in a folder. I would like to import only certain columns from those files and plot those columns in one single graph.

Answer 1

[Azzi Abdelmalek]

range='B:C'   % column B and C
xlsread('file.xlsx',range)

[ghost]

I was looking for a way to pull column B and C from multiple files and plotting on one single graph

[Tien Tran]

A = zeros(1000,2); A(:,1) = xlsread('file1.xlsx',range); A(:,2) = xlsread('file2.xlsx',range); Hope it is useful