How to import data from excel file as structure into Matlab?
64 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Jannis Holtkoetter
il 29 Ott 2020
Modificato: Walter Roberson
il 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 Commenti
Risposta accettata
Walter Roberson
il 30 Ott 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 Commenti
vishal kulkarni
il 19 Apr 2022
If column has special charcater in it, it fails.
Like,
Param1.Field1 -> this will fail
Walter Roberson
il 19 Apr 2022
Modificato: Walter Roberson
il 19 Apr 2022
User indicated that the second columns are all numeric scalars.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!