How to import data from excel file as structure into Matlab?

Hello, I have a relatively straight forward problem:

I have an excel sheet with two columns. The first column contains names and the second column contains numeric values. How can I import this file as a struct, so that I can access the values simply by their name?

[Walter Roberson]

Are the values all the same datatype such as all numeric scalars?

[Jannis Holtkoetter]

Yes the values are all numeric scalars

Answer 1

[Walter Roberson]

T = readtable(TheFileName);
TC = table2cell(T);
TS = cell2struct(TC(:,2), TC(:,1), 1);

TS will now be a cell with field names according to the first column of the file and numeric value according to the second column of the file.

[Jannis Holtkoetter]

Thank you very much!

I only needed to MATLAB to stop using the first row as the header, otherwise the information of the first row would have been lost. Then, everything works perfectly!

T = readtable('config_file.xls','ReadVariableNames',0);

[Walter Roberson]

That makes sense.

[vishal kulkarni]

If column has special charcater in it, it fails.

Like,

Param1.Field1 -> this will fail

[Walter Roberson]

User indicated that the second columns are all numeric scalars.