xlsread1 suggested by Antonio will take much time

4 次查看(过去 30 天)
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 个)

Chandrasekhar
Chandrasekhar 2014-3-19
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 个评论
Haibo
Haibo 2014-3-19
Thanks Akshata. What you suggested is to find out all of the Sheets. I have an excel file with 600 Sheets (12000*6). I used the code
File='C:\Users\Du\Desktop\jg.xlsx';
Excel = actxserver ('Excel.Application');
Excel.Workbooks.Open(File);
Excel.Workbooks.Item('jg.xlsx').RunAutoMacros(1);
if ~exist(File,'file')
ExcelWorkbook = Excel.Workbooks.Add;
ExcelWorkbook.SaveAs(File,1);
ExcelWorkbook.Close(false);
end
Excel.Workbooks.Open(File);
to read the excel file. It will take 234s. Is it too slow?
Chandrasekhar
Chandrasekhar 2014-3-19
I think there is no other method which executes faster than activex.

请先登录,再进行评论。

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by