xlsread1 suggested by Antonio will take much time

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?

[Chandrasekhar]

try to use activex server commands

Answer 1

[Chandrasekhar]

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

[Haibo]

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]

I think there is no other method which executes faster than activex.