xlsread1 suggested by Antonio will take much time
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I used the xlswrite1 code (proposed by Matt, http://www.mathworks.com/matlabcentral/fileexchange/10465-xlswrite1) to write many similar matrix into one excel file with various Sheets. It worked well, so fast. However, reading this excel file using the xlsread1 code will take much time. For example, 600 Sheets will take 5 mins. Is it normal?
1 commentaire
Réponses (1)
Chandrasekhar
le 19 Mar 2014
Excel = actxserver('Excel.Application');
workBook = Excel.Workbooks.Open('filename.xls');
workSheets = Excel.Sheets;
for i = 1:workSheets.Count
sheet = get(workSheets,'item',i);
sheetName{i} = sheet.Name;
end
2 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!