Export nested cell array to excel
조회 수: 10 (최근 30일)
이전 댓글 표시
I have a nested cell array where each cell has three columns but different number of rows. I need to export the values to excel keeping the columns intact but using writecell gives me an error 'Nested cell arrays are not supported'. How can I export the values to excel?
Here's a quick example:
A1 = {1,1,1};
A2 = {2,2,2;2,2,2};
A3 = {3,3,3;3,3,3;3,3,3;};
A = {A1, A2, A3};
writecell(A, 'mydata.xlsx');
댓글 수: 0
답변 (1개)
Vilém Frynta
2023년 3월 16일
편집: Vilém Frynta
2023년 3월 16일
You could just try to avoid using the cells, and just create one big matrix (array) with NaNs and then fill in your data. However, this would be an easy workaround just in case you have just these few columns and numbers. If you have much more numbers and columns, it could be bit trickier.
See my example:
m = NaN([3 6])
m(1:3,1) = [1 1 1]
... and go on.
Hope I helped.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!