Export data from cell matrix to excel

15 views (last 30 days)
EldaEbrithil
EldaEbrithil on 24 Jun 2020
Commented: EldaEbrithil on 24 Jun 2020
Hi
i wanto to export all the cell and their relative values contained in Ysol (it contains numerous cells) to an excel file, how can i do that?
forum2.png are the data in each one cell
forum1.png is the Ysol cell matrix view
I have tried with
xlswrite('datiMachlaminar.xls',YSol{:}(:));
but it gives me error
Regards
  2 Comments
EldaEbrithil
EldaEbrithil on 24 Jun 2020
Expected one output from a curly brace or dot indexing expression, but there were 364 results.
Error in Secondavariante (line 171)
xlswrite('datiMachlaminar.xls',YSol{:}(:));

Sign in to comment.

Answers (1)

Aakash Mehta
Aakash Mehta on 24 Jun 2020
Assuming your Ysol is looks like this.
C = {1,2,3;
4,5,6;
7,8,9;
10,11,12;
13,14,15}
You can convert it to excel file by below lines of code.
C=num2cell(cell2mat(C.'));
xlswrite('x.xlsx',C)
  2 Comments
EldaEbrithil
EldaEbrithil on 24 Jun 2020
Ok solved:
for i=1:length(L)
for j=1:length(Mo1)
theArray(i,j) = {YSol{i,j}(:,3)};
end
end
Arr=cell2mat(theArray);
xlswrite('datiMachlaminar', Arr);
Thi code extrapolate only the third column

Sign in to comment.

Categories

Find more on Linear Algebra in Help Center and File Exchange

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by