poster
2019-11-25, 15:26
<p>i got a cell array looks like this</p>
<pre><code>'NIPPON TELEGRAPH & TELPHONE COR'
'IMMERSION CORP'
[]
'NISSAN MOTOR CO LTD'
[]
[]
[]
[]
<1x5 cell>
'STERIS CORP'
<1x134 cell>
[]
<1x4 cell>
[]
<1x2 cell>
</code></pre>
<p>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?</p>
More answer... (https://stackoverflow.com/questions/18911042/how-to-export-a-cell-array-into-excel-with-matlab)
<pre><code>'NIPPON TELEGRAPH & TELPHONE COR'
'IMMERSION CORP'
[]
'NISSAN MOTOR CO LTD'
[]
[]
[]
[]
<1x5 cell>
'STERIS CORP'
<1x134 cell>
[]
<1x4 cell>
[]
<1x2 cell>
</code></pre>
<p>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?</p>
More answer... (https://stackoverflow.com/questions/18911042/how-to-export-a-cell-array-into-excel-with-matlab)