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!!

采纳的回答

Scott MacKenzie
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 个)

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by