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

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

Answer 1

[Azzi Abdelmalek]

Use xlsread to import your excel file, then do what you want with it

[Jamie Shelley]

Thanks, but I think I didn't explain well what I meant - I extracted data from a large text file containing 85 experiments, and now each experiment is saved in a single cell in a 1x85 cell array - However, I need the experiments in the form of the example I provided (which is just one I started doing manually) but can't get the data from the cells into the format I need them in

[Azzi Abdelmalek]

You can explain your problem with a short example

data={[1 2;4 5],[6 7;8 9], [10 11 ;12 13]}  % Example
out=cell2mat(data)

[Jamie Shelley]

Thanks, I've tried using cell2mat but unfortunately it gives every character in a different cell as opposed to giving it in table form

[Azzi Abdelmalek]

You have to tell if my example correspond to your data, or post an example. You don't need to post all your data, just a sample!

[Azzi Abdelmalek]

Maybe your data looks like this

data={{'a','b';1 2;4 5},{'a' 'b';6 7;8 9}, {'a','b';10 11 ;12 13}}
out=[data{:}]

[Jamie Shelley]

yeah sorry, I realised it had headers on so used the version without headers, and it worked for one table so a definite step forward, thank you! However, is tehre a way of looping it or something to have all of the experiments in the form of the example I provided please? I tried doing it one by one inside a loop plotting each graph one by one but the program took about 3 minutes to run and the graphs I got were wrong, so it would be a lot easier if it could be sent to excel in the format with all of the tables. Thanks for your help!

[Jamie Shelley]

I don't really know how to give you a sample, is there a way of uploading a variable from my workspace? It's basically just a cell array where every cell contains one of the tables as shown in the example.xlsx

[Jamie Shelley]

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

[Azzi Abdelmalek]

You can save your variable in a mat file, then upload your file

save filename yourvariable