Creating Array Struct From excel file
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I am trying to create an appropriate array from an excel sheet. I have read the sheet with [num str]=xlsread('Book1.xlsx'); This creates Name Size Bytes Class Attributes
num 5x10 400 double
and
Name Size Bytes Class Attributes
str 6x10 6920 cell
I would like to create a struct such that the field names coming from the row headers of str. but if i try
B=struct(str(1,1),num(:,1))
I get an error
Error using struct
Field names must be strings.
Please suggest a work around if you know of one. Thank you
0 Commenti
Risposta accettata
Jan
il 10 Lug 2013
Your str is a cell string. Then you need curly braces:
B = struct(str{1,1}, num(:,1))
0 Commenti
Più risposte (1)
David Sanchez
il 10 Lug 2013
field_name = 'field_to_be';
myStruct.(field_name) = 4;
>> myStruct
myStruct =
field_to_be2: 4
3 Commenti
Jan
il 10 Lug 2013
@David: Instead of explaining, that we should ignore the "2", you can simply edit your question and delete it.
Vedere anche
Categorie
Scopri di più su Structures 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!