extract large text from cell to put it into multiple cells in excel
3 views (last 30 days)
Show older comments
Jamie Shelley
on 7 Aug 2016
Commented: Azzi Abdelmalek
on 7 Aug 2016
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 Comments
Accepted Answer
Azzi Abdelmalek
on 7 Aug 2016
Use xlsread to import your excel file, then do what you want with it
9 Comments
Azzi Abdelmalek
on 7 Aug 2016
You can save your variable in a mat file, then upload your file
save filename yourvariable
More Answers (0)
See Also
Categories
Find more on Loops and Conditional Statements in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!