Iteratively selecting excel files
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentar
Geoff Hayes
am 16 Aug. 2014
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?
Antworten (1)
Image Analyst
am 16 Aug. 2014
Bearbeitet: Image Analyst
am 16 Aug. 2014
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.
3 Kommentare
Image Analyst
am 23 Aug. 2014
Maybe try to go find Geoff at your other thread http://www.mathworks.com/matlabcentral/answers/147292-chossing-random-data-from-xls-files
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!