How do I import a number of excel files at once?

1 次查看（过去 30 天）
Franchesca
Franchesca 2014-4-21
编辑： Mischa Kim 2014-4-21
I have wrote this loop to import a number of excel files at once and it works:
numfiles = 54; % number of excel files mydata=cell(numfiles,1); % defining size of mydata
for k = 7:numfiles % loop to import mutliple excel files
myfilename = sprintf('Trial %d', k); % define file name
mydata{k} = xlsread(myfilename); % import files into mydata
end
How do I edit this to only import columns 1 to 5 in each excel file??

请先登录，再回答此问题。

采纳的回答

Mischa Kim
Mischa Kim 2014-4-21
编辑：Mischa Kim 2014-4-21
Use
xlsread(myfilename,'A:E')
or any other range of data columns.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by