Reading excel files in a directory

2011 7 19
1 个回答
回答已采纳
3 次查看（30 天）

0 个投票

I have many excel files (.xlsx format) in a directory with names R1,R2,R3....R89. Is it possible to read them one by one to execute certain commands and save them back without having to do it manually?

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

 采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-7-19

0 个投票

Something like this:
for k=1:89
FileName=['R',num2str(k)];
data=xlsread([FileName,'.xlsx']);
% do stuff on data
xlswrite([FileName,'_Output.xlsx'],data);
end

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by