Replace Header & Append new row in writetable
3 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
Scott MacKenzie
on 4 May 2021
Edited: Scott MacKenzie
on 4 May 2021
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.
More Answers (0)
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!