Write cell array to excel format with xlswrite

Question

Wout Depoot 2020-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/515474-write-cell-array-to-excel-format-with-xlswrite

评论： Wout Depoot 2020-4-5

Hello,

I have a cell array AllCoverage containing 4 cell arrays each containing 3 columns and I want to write this out to an excel file.

I tried the following code:

xlswrite('AllCoverage.xls',{'WO_1','WO_2','BL_1','BL_2'};AllCoverage{1},AllCoverage{2},AllCoverage{3},AllCoverage{4});

But i'm getting the following error:

Error: File: Volumes.m Line: 13 Column: 57

Invalid expression. When calling a function or indexing a variable, use parentheses. Otherwise, check for

mismatched delimiters.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Wout Depoot 2020-4-5

Thanks in advance!

请先登录，再进行评论。

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

Answer 1

Thiago Henrique Gomes Lobato 2020-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/515474-write-cell-array-to-excel-format-with-xlswrite#answer_424108

在 MATLAB Online 中打开

You need to check the syntax of xlswrite, then you see that you're calling it with wrong arguments. You have to transform your array in one single cell structure and pass it only that structure to the function. The use of ";" is also wrong, every time you use it you tell matlab that the line/command is over, so using it give you this error. I'm not entirerly sure how you want your data, but an example that could work based in your description is this one:

CellTosave = cell(2,12);
CellTosave{1,1} = 'WO_1';
CellTosave{1,4} = 'WO_2';
CellTosave{1,7} = 'BL_1';
CellTosave{1,10} = 'BL_2';
CellTosave{2,1} = AllCoverage{1};
CellTosave{2,4} = AllCoverage{2};
CellTosave{2,7} = AllCoverage{3};
CellTosave{2,10} = AllCoverage{4};
xlswrite('AllCoverage.xls',CellTosave);