How can I write the cell array to an excel

2 次查看（过去 30 天）

显示更早的评论

Jonathan Babitsch 2020-7-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/565916-how-can-i-write-the-cell-array-to-an-excel

回答： Walter Roberson 2020-7-18

采纳的回答： Walter Roberson

Spline_neu_1.m

Hey everybody,

How can I write my cell array to an excel file?

It is a cell array of the dimension 1*101.

I also attached the code, it is pretty simple. What I am trying to do is write the cell Array P to an excel file.

Thanks a lot in advance,

Johnny

7 个评论
显示 5更早的评论隐藏 5更早的评论

Jonathan Babitsch 2020-7-17

Wow that was easy, sorry for annoying you...

Thanks heaps Walter!!

Jonathan Babitsch 2020-7-18

Is there a possibility to mark your comment as accepted answer because it was you who led me the right way?

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2020-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/565916-how-can-i-write-the-cell-array-to-an-excel#answer_467745

cell2mat() the cell array, and if necessary, transpose it with .'

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

更多回答（1 个）

KSSV 2020-7-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/565916-how-can-i-write-the-cell-array-to-an-excel#answer_466508

To write an cell array into xlfile, you can use xlsread, writetable.

https://in.mathworks.com/help/matlab/ref/writetable.html

https://in.mathworks.com/help/matlab/ref/xlswrite.html

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

Jonathan Babitsch 2020-7-16

That doesn't help, whatever I use it doesn't do what I want...

My goal is to write the first Vector in the Array to A1:C1, the second in A2:C2 and so on until A101:C:101...

My idea:

writecell(P,'C.xls','Sheet',1,'Range','A1:C101')

But that doesn`t work, any suggestions whats missing?

请先登录，再进行评论。

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

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by