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

2 次查看（过去 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 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by