Write nested cell array data into separate excel sheets

2022 3 18
1 个回答
回答已采纳
更新时间：2022 3 18
2 次查看（30 天）

0 个投票

Hi all,
I have a nested array data (5 rows and 7 columns) and would like to save the results of each row onto separate excel sheets. In my case, I have 5 rows of nested cell data where I would like to have 5 excel sheets with sheet names representing the ID of the user.
Any help in this is highly appreciated. I have attached the data.

请先登录，再回答此问题。

 采纳的回答

Arif Hoq
Arif Hoq 2022-3-18
编辑：Arif Hoq 2022-3-18

0 个投票

try this:
A=load('Data3.mat');
B=A.Tc ;
firstrow=[B{1,:}];
% C=string(firstrow);
writecell(firstrow,'filename1.xlsx')
secrow=[B{2,:}];
writecell(secrow,'filename2.xlsx')
thirdrow=[B{3,:}];
writecell(thirdrow,'filename3.xlsx')
upto row 5....

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Ganesh Naik
Ganesh Naik 2022-3-18
Hi Arif, thanks for your answer. Using your method, I can extract individual row data to seprate Excel files. I wanted these Excel files as one excel file with different sheets (in my case 5) and also would like to get it done automatically say using the loop etc. Because some instances I may end up 10 rows or more. First I will understand the logic and try to work it out. Any suggestions or modifications from your end is higlhly appreciated. Also, once I find the solution I will accept your answer.
Ganesh Naik
Ganesh Naik 2022-3-18
I have figured out the answer. I am posting the detailed answer, Hope it is helpful to others.
If "Tc" is the nested cell array (refer to the Figure) then the following code creates separate Excel files for each nested row.
for i=1:numel(Tc(:,1))
Row= [Tc{i,:}]
writecell(Row,['filename' num2str(i) '.xlsx'])
end

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by