xlsread1 suggested by Antonio will take much time

5 views (last 30 days)
Haibo
Haibo on 19 Mar 2014
Commented: Chandrasekhar on 19 Mar 2014
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?

Answers (1)

Chandrasekhar
Chandrasekhar on 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 Comments
Chandrasekhar
Chandrasekhar on 19 Mar 2014
I think there is no other method which executes faster than activex.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!