CODEWITHSUNDEEP
excelmatlabxlsread
Eghbal
Eghbal

Reputation: 3803

Opening all sheets of a spreadsheet by single call of xlsread in MATLAB

We can extract specific sheet using this function in MATLAB:

out = xlsread(filename,sheet);

How we can extract more than one sheet using single call of this function? I don't want use a loop and read the the file again and again for extracting different sheets data.

Upvotes: 0

Views: 97

Answers (1)

Daniel
Daniel

Reputation: 36720

xlsread does not support reading multiple sheets at once. You have to use a loop.

As an alternative you could create your own xlsread function which has more capabilities. The relevant code is placed in toolbox\matlab\iofun\xlsread.m and toolbox\matlab\iofun\private\xls*.m You could create a copy of these functions and modify them to support multiple sheets.

Upvotes: 1

Related Questions