How to import data from excel file as structure into Matlab?
62 views (last 30 days)
Show older comments
Jannis Holtkoetter
on 29 Oct 2020
Edited: Walter Roberson
on 19 Apr 2022
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?
2 Comments
Accepted Answer
Walter Roberson
on 30 Oct 2020
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.
4 Comments
vishal kulkarni
on 19 Apr 2022
If column has special charcater in it, it fails.
Like,
Param1.Field1 -> this will fail
Walter Roberson
on 19 Apr 2022
Edited: Walter Roberson
on 19 Apr 2022
User indicated that the second columns are all numeric scalars.
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!