How do I import data from multiple pages in an xls-file to an x*y*z-matrix?

Hi,

I am working with time-series data in a multi-page spreadsheet and would like to import it. Each pages have 17 variables over the time-span of 70 years and there are 25 pages. I can use [num, txt, raw] = xlsread('file.xls','pagename') to access the table in one individual page, but i would like to import it as a tensor if possible, to store it in a [X,Y,Z]-format, like as if the all the tables are "stacked on top of each other".

Would be neat if all the data for page 3 could be accessed simply by [:,:,3], or a specific value by on that page by, for example, [7,2,3].

My first instinct was to make a loop, but since the arguments in xlsread are strings I don't know how to do it. Is there a proper way?

[darova]

Can't you use number of sheets?

A = xlsread('file.xls',1);

Answer 1

[Cris LaPierre]

If the variables are the same in each sheet, readtable can be used to create a table datatype. You can then append the table from each sheet together. MATLAB will automatically align the tables by variable name. Maybe something like this (untested)?

[status, sheetNames] = xlsfinfo('file.xls');

% read in the first sheet
data = readtable(fullFileName, 'Sheet', 1)

% Read data from the remaining sheets
for s=2:length(sheetNames)
    temp = readtable(fullFileName, 'Sheet', s);
    
    % append to the table 
    data = [data;temp];
end