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

1 view (last 30 days)
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

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 7 Aug 2016
Use xlsread to import your excel file, then do what you want with it
Azzi Abdelmalek
Azzi Abdelmalek on 7 Aug 2016
You can save your variable in a mat file, then upload your file
save filename yourvariable

Sign in to comment.

More Answers (0)


Find more on Data Import from MATLAB 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!