extract large text from cell to put it into multiple cells in excel

3 次查看（过去 30 天）
Jamie Shelley
Jamie Shelley 2016-8-7
评论： Azzi Abdelmalek 2016-8-7
I have a variable that contains a table in each cell, but I need it to be in the form shown in 'example.xlsx' is there a way of doing that please?
So to make it more clear, I've extracted the details of 85 experiments from a .txt file into matlab using fileread, but that returned a 1x85 cell array, with each cell containing the table for an experiment - however, I need to send these details from matlab, to excel - but in the form shown in the example I provided (which I made manually) but when I send it to excel, it sends each table to a single cell as opposed to sending it in the format I need it in. Hope that's a clearer explication, I realise I wasn't very clear at first. Thanks

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2016-8-7
Use xlsread to import your excel file, then do what you want with it
  9 个评论
显示 7更早的评论
Jamie Shelley
Jamie Shelley 2016-8-7
Ahh I worked out a way! An incredibly inefficient and stupid way but it worked and at this point, that's all I care about hahah. Thanks for the guidance, I wouldn't have gotten it without the cell2mat thing

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by