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

2016 4 8

1 个回答

6 次查看（30 天）

0 个投票

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Azzi Abdelmalek 2016-4-8

0 个投票

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

ghost 2016-4-12

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

Tien Tran 2016-4-12

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

在帮助中心和 File Exchange 中查找有关 Spreadsheets 的更多信息

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by