xlsread1 suggested by Antonio will take much time
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentario
Respuestas (1)
Chandrasekhar
el 19 de Mzo. de 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 comentarios
Chandrasekhar
el 19 de Mzo. de 2014
I think there is no other method which executes faster than activex.
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!