How to import data from excel file as structure into Matlab?
35 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Jannis Holtkoetter
el 29 de Oct. de 2020
Editada: Walter Roberson
el 19 de Abr. de 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 comentarios
Walter Roberson
el 29 de Oct. de 2020
Are the values all the same datatype such as all numeric scalars?
Respuesta aceptada
Walter Roberson
el 30 de Oct. de 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 comentarios
vishal kulkarni
el 19 de Abr. de 2022
If column has special charcater in it, it fails.
Like,
Param1.Field1 -> this will fail
Walter Roberson
el 19 de Abr. de 2022
Editada: Walter Roberson
el 19 de Abr. de 2022
User indicated that the second columns are all numeric scalars.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!