Replace Header & Append new row in writetable
3 次查看(过去 30 天)
显示 更早的评论
I have a cell array say
testarray={'1 2 3'; '3 4 5'}
And desired header to be
col1 col2 col3
How do I write table in excel that looks like this
col1 col2 col3
1 2 3
3 4 5
Thank you!!
0 个评论
采纳的回答
Scott MacKenzie
2021-5-4
编辑:Scott MacKenzie
2021-5-4
testarray={'1 2 3'; '3 4 5'}
z = split(testarray);
T = array2table(z)
T.Properties.VariableNames = { 'col1', 'col2', 'col3' }
T =
2×3 table
col1 col2 col3
_____ _____ _____
{'1'} {'2'} {'3'}
{'3'} {'4'} {'5'}
Or, if you want a table of numeric data:
testarray={'1 2 3'; '3 4 5'}
z = split(testarray);
s = string(z);
d = double(s);
T = array2table(d)
T.Properties.VariableNames = { 'col1', 'col2', 'col3' }
T =
2×3 table
col1 col2 col3
____ ____ ____
1 2 3
3 4 5
There might be some tricks to trim down the code, not sure.
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!