Replace Header & Append new row in writetable

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

Answer 1

[Scott MacKenzie]

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.

[chlor thanks]

Thank you Scott!!