I am currently working on a project where i have data from several subjects in an excel file. Subjects are specified on Sheet 1 of the excel file. However, these subjects were invited every three months, I have 11 sheets of datasets. From each of the dataset I want to analyse one item which is stored under a specific name. To begin with my problem is, that the table 'data' will only contain 73 lines. Why does this happen?
[~,sheets] = xlsfinfo('filename.xlsx')for s = 1:numel(sheets)[data] = readtable('filename.xlsx','Sheet',(s))end