How can I process a sequence of EXCEL files inside a FOR loop
1 次查看(过去 30 天)
显示 更早的评论
i have n numbers of excel files like this : mydata1.xlsx , mydata2.xlsx , mydata3.xlsx and so on . Now i want to process each of the excel file iteratively in a FOR loop . This is what , i have tried so far
for i =1:n
fprintf('Enter the Excel file name \n');
m=input('');
M= xlsread(m);
.
.
.
MY codes
.
.
end
But Its not working . Kindly help me . Thankx in advance.
0 个评论
采纳的回答
Orion
2014-10-6
Hi,
You need to do a loop like this :
for i = 1:n
% ask the user the name of excel file (without the extension)
XlsFile = input('Enter the Excel file name : ','s');
% Read the spredsheet by adding the _.xlsx_ string to the Xls filename
XlsData = xlsread([XlsFile '.xlsx']);
% then : code to process XlsData
end
You might consider to remove the input of the for loop and define your xls files before, otherwise the user has to be ready to write at each iteration, which can take a long time.
更多回答(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!