extract large text from cell to put it into multiple cells in excel
3 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
采纳的回答
Azzi Abdelmalek
2016-8-7
Use xlsread to import your excel file, then do what you want with it
9 个评论
Azzi Abdelmalek
2016-8-7
You can save your variable in a mat file, then upload your file
save filename yourvariable
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!