Consolidating cells to an xlsx file

Question

sai prasanna sai prasanna m s 2023-4-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1945039-consolidating-cells-to-an-xlsx-file

评论： dpb 2023-4-12

I have data in this format

Variables A...Z

A = 1x408 cell

B = 1x408 cell

C = 1x408 cell

.

Z = 1x408 cell

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 个评论
显示 1更早的评论隐藏 1更早的评论

sai prasanna sai prasanna m s 2023-4-12

I got these variables in a .mat file

Stephen23 2023-4-12

编辑：Stephen23 2023-4-12

在 MATLAB Online 中打开

"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:

https://www.mathworks.com/help/matlab/matlab_prog/generate-field-names-from-variables.html

and also comma-separated lists:

https://www.mathworks.com/help/matlab/matlab_prog/comma-separated-lists.html

https://www.mathworks.com/matlabcentral/answers/1656435-tutorial-comma-separated-lists-and-how-to-use-them

"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.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2023-4-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1945039-consolidating-cells-to-an-xlsx-file#answer_1213449

移动：dpb 2023-4-11

在 MATLAB Online 中打开

"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 个评论
显示 2更早的评论隐藏 2更早的评论

sai prasanna sai prasanna m s 2023-4-12

I got these variables in a .mat file.

dpb 2023-4-12

在 MATLAB Online 中打开

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.

请先登录，再进行评论。