Export data from MATLAB table to new table in Excel

Question

Rachael Courts 2020-5-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/532543-export-data-from-matlab-table-to-new-table-in-excel

评论： rubindan 2020-6-15

See image below for reference.

I have created a 5763 x 15 table named 'data' which you can see in my workspace. I am wanting to export all information (including headers) from this table into xlsx.

I thought I'd try code on just 3 columns to see if I could get it working. For all the coding I have tried I receive 'T' as just 3 header columns without any information within the rows.

In the image you will see a few of the many attempts I have tried. Any help would be welcomed!

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

请先登录，再进行评论。

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

Answer 1

rubindan 2020-5-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/532543-export-data-from-matlab-table-to-new-table-in-excel#answer_437973

在 MATLAB Online 中打开

To use writetable(T) the object T must be a table class object, created with the table command.

In your case T is a cell array of three strings. The correct form to use would be

id = some_vector_of_numbers;
UTS = anouther_vector;
startSeconds = yet_another_vector;
T = table(id,UTS,startSeconds);
writetable(T,'data.xlsx')

Matlab will use the column names id,UTS, and startSeconds for the header.

2 个评论
显示无隐藏无

Rachael Courts 2020-6-11

Hi Rubindan,

I've just tried your suggestion now. As a MATLAB novice I'm unsure what 'some_vector_of_numbers' is supposed to be. I tried this

Id = 5763

UTC = 5763

startSeconds = 5763

T = table(Id,UTC,startSeconds)

writetable(T,'data.xlsx')

The above just gave an output of T 1x3 where each column was the headers suggested above, not showing any data?

I also tried changing '5763' to '5763x15' but it didnt work, I'm getting these numbers from the table where I want the data to come from, see below.

rubindan 2020-6-15

I was thinking that id, startSeconds, and UTS are columns in your table, but now I see that your table has 15 columns. In thaty case I do not undesrant what they are.

To save the table as it is just type writetable(data,'data.xlsx')

请先登录，再进行评论。