What is the best way to organize two header lines in a Table?

Hallo, Thanks for Reading!

My dataset has two header lines. The dataset is read from a '*.xlxs' file where line 1 contains the Variable Group names and Line 2 contains Variable Names. I need both for my data classification and exploration. How can I read it with readtable function?

I have tried detectImportOptions with VariableUnitsLine and VariableDescriptionsLine. Everytime, MATLAB returned the following error.

Error:
Unrecognized property '*' for class
'matlab.io.spreadsheet.SpreadsheetImportOptions'.

If possible, could you give me an example on how to organize them ?

Example:

% Line 1: Climate Data
% Line 2: {'Temperature', 'Humidity'}

[Scott MacKenzie]

If you know that "Temperature" and "Humidity" are categories within "Climate Data", perhaps you can just skip the first line, using

T = readtable('filename.xlsx', 'numheaderlines', 1);   

The column variable names will be "Temperature" and "Humidity".

[Walter Roberson]

Are you trying to pass in literally *.xlsx to detectImportOptions() complete with the * ?

[Kazi Alam]

@Walter Roberson No. I have an actual *.xlsx file name. For simplying my question formulation I used '*'.

[Kazi Alam]

@Scott MacKenzie I am not familier with the core language of the system which generates the *.xlsx file. Thats why I need both header lines to fulfill my purpose.

[Walter Roberson]

If you detectImportOptions() passing in just the file name, then do you still get th eerror about unrecognized property '*' ? Please show the complete error message. And is it literal '*' or did you replace the file name with '*' in the error message ?

[Kazi Alam]

@Walter Roberson the error message was original. I didn't replace with '*'.

[Walter Roberson]

Could you confirm you get that even with detectImportOptions() with only a file name?

Please post the complete error message, showing the lines numbers and line contents.

[Kazi Alam]

@Walter Roberson

Code lines:

filePath = fullfile(dL,ff(sBx({ff.name})).name);
opts = detectImportOptions(filePath,'NumHeaderLines',1);                    
opts.VariableNamesLine = 2; 
data = readtable(filePath,opts);

Error:

Unrecognized property 'VariableNamesLine' for class

'matlab.io.spreadsheet.SpreadsheetImportOptions'.

[Kazi Alam]

@Walter Roberson, there is no additional information such as the lines numbers or line contents.

[Walter Roberson]

opts.VariableNamesRange = 2; 

[Kazi Alam]

Now I have the following error.

Error using matlab.io.ImportOptions/readtable (line 653)

Comparison between double and string is not supported.

[Walter Roberson]

I am not sure which version you are using; current versions specifically permit a vector of integers for the VariableNamesRange see https://www.mathworks.com/help/matlab/ref/matlab.io.spreadsheet.spreadsheetimportoptions.html#bvetiw8-1_sep_bvetiw8-1-VariableNamesRange

But you could try

opts.VariableNamesRange = '2:2'; 

Answer 1

[Walter Roberson]

If you must use readtable() then you are going to need two calls, one to read the first header line.

Alternately you could use readcell() and extract the first header line and construct a table from the remaining lines.