Iteratively selecting excel files

Question

Muhammad Usman 2014-8-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/151023-iteratively-selecting-excel-files

评论： Muhammad Usman 2014-8-23

Hi,i have around 1500 excel files in a folder with almost 900 x 130 cells of data in each file and i want to read (xlsread) one-by-one by randomly selected some rows from each file and this process continues to all files and then write (xlswrite) step by step to a new file. Please give some hint... Thanks

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Geoff Hayes 2014-8-16

Muahmmad - I gave a hint at http://www.mathworks.com/matlabcentral/answers/147292-chossing-random-data-from-xls-files. Did you try to code that up?

请先登录，再进行评论。

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

Answer 1

Image Analyst 2014-8-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/151023-iteratively-selecting-excel-files#answer_148828

编辑：Image Analyst 2014-8-16

在 MATLAB Online 中打开

ExcelDemo.m

Geoff, he accepted it but I doubt he actually tried to code anything. If I were to do this, I'd use the FAQ http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F to loop over every xlsx file. Then use ActiveX calls to do the transfer of data:

myFolder = 'C:\my Excel workbooks';
if ~isdir(myFolder)
  errorMessage = sprintf('Error: The following folder does not exist:\n%s', myFolder);
  uiwait(warndlg(errorMessage));
  return;
end
filePattern = fullfile(myFolder, '*.xls*');
% TO DO: ActiveX call to open Excel.
% TO DO: ActiveX call to open output workbook
excelFiles = dir(filePattern);
for k = 1:length(excelFiles)
  baseFileName = excelFiles(k).name;
  fullFileName = fullfile(myFolder, baseFileName);
  fprintf(1, 'Now reading %s\n', fullFileName);
  % TO DO: ActiveX call to open workbook
  % TO DO: ActiveX call to get number of rows
  % TO DO: Call to randi(numberOfRows, 1,1) to get random starting and ending rows.
  % TO DO: ActiveX call to read the data from the input workbook.
  % TO DO: ActiveX calls to send data to output workbook.
  % TO DO: ActiveX calls to close input workbook
end
% TO DO: ActiveX calls to save and close output workbook
% TO DO: ActiveX calls to quit Excel: Excel.Quit
% TO DO: delete Excel object: delete('Excel')

I attach an ActiveX demo that you will easily be able to adapt, or at least you should be able to.

The reason for using ActiveX, instead of xlsread() and xlswrite(), is that you want to process these 1500 files in a finite amount of time. If you don't use ActiveX it could take hours instead of minutes.

Also, I don't know what is interactive about this. You said you want to process them one by one. If you don't want all of them in the folder but just user-chosen ones, then skip the call to dir() and put a call to uigetfile() inside the loop, though with 1500 files there is no way on earth your use will remember which files have been processed yet and which have not, and thus will not know which file to select.