MATLAB: How to read units on a 2nd row out of an Excel file

MATLABreadtable

Attached is an example Excel file.

I'm using this command to read the info out of the file:

T1 = readtable('test.xlsx', 'PreserveVariableNames',true);

Here is my question. How do I read the units out of the 2nd row?

Thanks!

filename = 'test.xlxs';
opt = detectImportOptions(filename);
opt.VariableUnitsRange = '2:2';      %row number
T1 = readtable(filename, opt);

T1.Properties.VariableUnits will be set.

I suspect to your 'FY20' is meant to be the sheet name. Unlike xlsread, with readtable the sheet name is passed as a Name-Parameter argument:

A = readtable('test.xlsx', 'Sheet', 'FY20', 'PreserveVariableNames',true);

"When reading:

Text files, only these parameter names apply: FileType, ReadVariableNames, ReadRowNames, TreatAsEmpty, DatetimeType, Delimiter, HeaderLines, Format, EmptyValue, MultipleDelimsAsOne, CollectOutput, CommentStyle, ExpChars, EndOfLine, DateLocale, and Encoding.
Spreadsheet files, only these parameter names apply: FileType, ReadVariableNames, ReadRowNames, TreatAsEmpty, DatetimeType, Sheet, Range, Basic, and TextType.
Text or Spreadsheet files with the opts import options, only these parameter names apply: ReadVariableNames, ReadRowNames, DateLocale, Encoding, Sheet, and Basic. "

You are reading a spreadsheet file. You need to use Range instead of HeaderLines