Converting a cell array to excel file using write table - how to add headers and sheet name?

Question

Paul Barrette 2024-2-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080361-converting-a-cell-array-to-excel-file-using-write-table-how-to-add-headers-and-sheet-name

评论： Voss 2024-2-9

THRESH_DATA.mat

I am able to convert the 'THRESH_DATA' variable inside the attached to an Excel file - this is how my code does it (thanks, @Voss):

filename = 'THRESH_DATA.xlsx';

n = size(THRESH_DATA,1);

for ii = 1:n

T = table(THRESH_DATA{ii,:});

writetable(T,filename,'Sheet',ii);

end

The next step (which I was hoping to handle myself) is to include column headers and sheet names. For sheet names, I thought of:

% sheetNames = ('2000', '2001', '2002','2003', '2004', '2005','2006', '2007', '2008','2009', '2010', '2011',...

% '2012', '2013', '2014','2015', '2016', '2017','2018', '2019', '2020','2021', '2022');

writetable(T,filename,'Sheet',ii,'sheetNames')

but that doesn't work. Drawing from other posts (most using xlswrite), I thought I could used variableNames, somehow. Thanks!

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

Dyuman Joshi 2024-2-9

https://in.mathworks.com/help/matlab/matlab_prog/access-data-in-a-cell-array.html

请先登录，再进行评论。

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

Answer 1

Voss 2024-2-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080361-converting-a-cell-array-to-excel-file-using-write-table-how-to-add-headers-and-sheet-name#answer_1405806

在 MATLAB Online 中打开

filename = 'THRESH_DATA.xlsx';
sheetNames = string(2000:2022);
% replace this with the variable names you want:
varNames = ["Time","X","Y","Z","AA","BBB","LMNOP","EIGHT","NOINE"];
n = size(THRESH_DATA,1);
for ii = 1:n
    T = table(THRESH_DATA{ii,:},'VariableNames',varNames);
    writetable(T,filename,'Sheet',sheetNames(ii));
end

2 个评论
显示无隐藏无

Paul Barrette 2024-2-9

This solution looks after both the sheet names and the headers. Thanks.

You're making this look so easy, @Voss.

Voss 2024-2-9

You're welcome! Glad to help

请先登录，再进行评论。

Answer 2

VBBV 2024-2-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080361-converting-a-cell-array-to-excel-file-using-write-table-how-to-add-headers-and-sheet-name#answer_1405796

编辑：VBBV 2024-2-9

在 MATLAB Online 中打开

sheetNames = {'2000', '2001', '2002','2003', '2004', '2005','2006', '2007', '2008','2009', '2010', '2011',...
    '2012', '2013', '2014','2015', '2016', '2017','2018', '2019', '2020','2021', '2022'};
writetable(T,filename,'Sheet',sheetNames{ii})