MATLAB: Xlsread for multiple sheets

xlsread

Hello,

Is it possible to import multiple sheets in an Excel workbook using a single call to xlsread? I have a ~100 MB spreadsheet with 72 tabs, each of which has the same format, which all need to be imported.

A single call of xlsread to this file takes about 45 seconds on my machine, and I'm wondering if there is a faster way than calling this function 72 individual times. Thanks a lot.

Matt

Best Answer

I don't think xlsread() currently supports it. You can use Excel COM server to speed up the process. Follow the link in this answer to see a brief introduction. The comments in the answer provide some code too.

http://www.mathworks.com/matlabcentral/answers/16299-is-there-instead-solution-of-xlsread

Related Solutions

MATLAB: Xlsread

You could use xlsfinfo() to get the sheet names and then you'll get the last sheet name.

[A, DESCR, FORMAT] = XLSFINFO('FILENAME')

Normally, 'DESCR' will return all the sheet names in a cell array.

MATLAB: XLSread – multiple sheets

Hi, Pratha.

I'm not sure if it helps or not because I also have similar situation with you but my parameter can combine in one excel file.

TimeP1=xlsread('Book001.xlsx','PRN1','A:A');
PRNP1=xlsread('Book001.xlsx','PRN1','B:B');
S4P1=xlsread('Book001.xlsx','PRN1','C:C');
%_______________read PRN1_______________%
TimeP2=xlsread('Book001.xlsx','PRN2','A:A');
PRNP2=xlsread('Book001.xlsx','PRN2','B:B');
S4P2=xlsread('Book001.xlsx','PRN2','C:C');
%_______________read PRN2_______________%

In another word:

ParameterP1 = xlsread('your excel file with format','your tab name in that excel','column selected');

Best Answer

Related Solutions

MATLAB: Xlsread

MATLAB: XLSread – multiple sheets

Related Question