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

64 visualizzazioni (ultimi 30 giorni)
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?

Risposta accettata

Walter Roberson
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
vishal kulkarni il 19 Apr 2022
If column has special charcater in it, it fails.
Like,
Param1.Field1 -> this will fail
Walter Roberson
Walter Roberson il 19 Apr 2022
Modificato: Walter Roberson il 19 Apr 2022
User indicated that the second columns are all numeric scalars.

Accedi per commentare.

Più risposte (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by