Consolidating cells to an xlsx file
1 次查看(过去 30 天)
显示 更早的评论
I have data in this format
Variables A...Z
.
.
Each element in the 1 X 408 cell of A-Z variables is a 1X1 cell.
I want to consolidate the data and generate an excel file that looks like this
Column names: A B C D E F .......... Z
Data values: A1 B1 C1 D1 ........................Z1
A2 B2 C2 D2 ........................Z2
.
.
.
A408 ..............................................Z408
Appreciate your inputs.
Thanks
Sai
3 个评论
Stephen23
2023-4-12
编辑:Stephen23
2023-4-12
"I got these variables in a .mat file"
To avoid the very bad situation that you are in, always LOAD MAT files into an output variable:
S = load(..)
Then process the content of the structure S. You will probably find many useful MATLAB functions to help you, e.g. FIELDNAMES, STRUCT2CELL, STRUCT2TABLE, dynamic fieldnames:
and also comma-separated lists:
"I have data in this format Variables A...Z"
Trying to process lots and lots of separate variables will force you into writing slow, complex, inefficient code. Best avoided.
回答(1 个)
dpb
2023-4-11
移动:dpb
2023-4-11
"I have data in this format"
A = 1x408 cell
B = 1x408 cell
C = 1x408 cell
That's your problem -- don't do that.
Create a single array of 26x408 to begin with; the result otherwise is, as you're discovering, very difficult to deal with effectively. We won't even talk about the slow, inefficient and difficult to debug alternatives -- "There be dragons...."
4 个评论
dpb
2023-4-12
What does
whos -file yourmatfilename.mat
return? Are these the only variables in the file or do you also have to find out "who's who in the zoo" in order to process the correct variables (and only the correct variables)?
As @Stephen23 points out, load-ing the .mat file into a struct variable then provides much more flexibility in writing code, but you still need to know something about what you're writing code for. But, that does open it up to using dynamic field names.
How to approach it depends in part on just what is in the file and if it can ever change its content--if it is immutable and unless it matches the contract to contain those specific variables and all of them and is nothing if that contract isn't met, then the single hardcoded line as given above may be a viable solution.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!