MATLAB Answers

Export data from cell matrix to excel

조회 수: 11(최근 30일)
EldaEbrithil
EldaEbrithil 24 Jun 2020
댓글: EldaEbrithil 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
EldaEbrithil
EldaEbrithil 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{:}(:));

댓글을 달려면 로그인하십시오.

답변(1개)

Aakash Mehta
Aakash Mehta 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
EldaEbrithil
EldaEbrithil 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

댓글을 달려면 로그인하십시오.

제품


릴리스

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by