How can I write the cell array to an excel

2 次查看（过去 30 天）
Jonathan Babitsch
Jonathan Babitsch 2020-7-16
回答： Walter Roberson 2020-7-18
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更早的评论
Jonathan Babitsch
Jonathan Babitsch 2020-7-17
Wow that was easy, sorry for annoying you...
Thanks heaps Walter!!
Jonathan Babitsch
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
Walter Roberson 2020-7-18
cell2mat() the cell array, and if necessary, transpose it with .'

更多回答（1 个）

KSSV
KSSV 2020-7-16
  1 个评论
Jonathan Babitsch
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?

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by