Export data from cell matrix to excel

3 次查看（过去 30 天）
EldaEbrithil
EldaEbrithil 2020-6-24
评论： EldaEbrithil 2020-6-24
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 2020-6-24
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 2020-6-24
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 2020-6-24
not exactly... the C you wrote is basically the a cell of YSol. YSol is a cell ensemble. I have tried your code:
YSol=num2cell(cell2mat(YSol.'));
xlswrite('datiMachlaminar.xlsx',YSol)
it gives me this error:
Error using cat
Dimensions of arrays being concatenated are not consistent.
Error in cell2mat (line 75)
m{n} = cat(2,c{n,:});
Error in Secondavariante (line 171)
YSol=num2cell(cell2mat(YSol.'));
EldaEbrithil
EldaEbrithil 2020-6-24
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

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by