writetable() to change header and append cell array in each row

Question

chlor thanks 2021-5-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/821375-writetable-to-change-header-and-append-cell-array-in-each-row

评论： Scott MacKenzie 2021-5-4

I have a cell array made of cell array tables such that

testarray
= 1×2 cell array
{1×3 table}    {1×3 table}  

And

testarray{1}
=  1×3 table
                   Var1                     Var2      Var3     
    ___________________________________    ______    ______ 
                    '1'                      '2'       '3'
testarray{2}
=  1×3 table
                   Var1                     Var2      Var3     
    ___________________________________    ______    ______ 
                    '3'                      '4'       '5'

And desired header to be

col1 col2 col3

How do I use writetable() to write this in excel that looks like

col1 col2 col3
1     2     3
3     4     5

Thank you!!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

chlor thanks 2021-5-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/821375-writetable-to-change-header-and-append-cell-array-in-each-row#answer_691750

summary = vertcat(testarray{:});

summary.Properties.VariableNames = { col1', 'col2', 'col3'}

writetable(summary, 'summary.xlsx');

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Scott MacKenzie 2021-5-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/821375-writetable-to-change-header-and-append-cell-array-in-each-row#answer_691755

在 MATLAB Online 中打开

t1 = table({'1'}, {'2'}, {'3'});
t2 = table({'4'}, {'5'}, {'6'});
t1.Properties.VariableNames = { 'col1', 'col2', 'col3' };
testarray = {t1, t2};
writetable(testarray{1}, 'test.txt');
writetable(testarray{2}, 'test.txt', 'writevariablenames', false, 'writemode', 'append');

In the command window...

>> type test.txt

col1,col2,col3

1,2,3

4,5,6

2 个评论
显示无隐藏无

chlor thanks 2021-5-4

Thanks Scott! This will help me learn!

By the way, when I try this code it says 'writemode' is a unvalid parameter name, also t2 didnt append.

Scott MacKenzie 2021-5-4

Gee, that's weird. I just re-ran the code, no problem. writetable dates to R2013a, so that's unlikely an issue. Of course, t2 did not append becuase the 2nd writetable crashed. I really don't know what the issue. If somone else reads this and has an idea, perhaps they'll weight in.

请先登录，再进行评论。