MATLAB爱好者论坛-LabFans.com - 查看单个帖子 - How to export a cell array into Excel with Matlab?

poster · 2019-11-25, 15:26

i got a cell array looks like this

'NIPPON TELEGRAPH & TELPHONE COR'

'IMMERSION CORP'

[]

'NISSAN MOTOR CO LTD'

[]

[]

[]

[]

<1x5 cell>

'STERIS CORP'

<1x134 cell>

[]

<1x4 cell>

[]

<1x2 cell>

This is a list of companies' name, the empty brackets means the name not available, <1x4 cell> means in that cell there are four companies' name. Now I want to export this array in to Excel, especially i want to put those <1x4 cell> alike cells in to four seperate cells in the same row in Excel. How can I do that?

2019-11-25, 15:26	#1
poster 高级会员注册日期: 2019-11-21 帖子: 3,006 声望力: 66	How to export a cell array into Excel with Matlab? i got a cell array looks like this `'NIPPON TELEGRAPH & TELPHONE COR' 'IMMERSION CORP' [] 'NISSAN MOTOR CO LTD' [] [] [] [] <1x5 cell> 'STERIS CORP' <1x134 cell> [] <1x4 cell> [] <1x2 cell>` This is a list of companies' name, the empty brackets means the name not available, <1x4 cell> means in that cell there are four companies' name. Now I want to export this array in to Excel, especially i want to put those <1x4 cell> alike cells in to four seperate cells in the same row in Excel. How can I do that? More answer...