how to export a time matrix to Excel

Question

zeezo 2016-5-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/283221-how-to-export-a-time-matrix-to-excel

评论： Image Analyst 2016-5-9

I have a time matrix a=[04:23:00; 05:34:22; 05:44:43]

I want to export this one to Excel. I tried but it put every time digit in a cell

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2016-5-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/283221-how-to-export-a-time-matrix-to-excel#answer_221361

在 MATLAB Online 中打开

That's not a time matrix. It's a matrix of 3 sequences, the first of which are null, and the last two just have the first element, strung together. So the entire array is [5,5].

Anyway, to write it out to Excel workbook, you do it just like any other variable

xlswrite(filename, a);

2 个评论
显示无隐藏无

zeezo 2016-5-9

Thank you but this one does not work because It separate each digit in a cell

Image Analyst 2016-5-9

That's because your matrix is not right. Please show the exact matrix. If you're using strings, you need to use single quotes around them, otherwise you get numbers, like I showed. If you have strings, you need to put them into cells before writing them out otherwise the string will go one character per column rather than the whole string into one Excel cell.

请先登录，再进行评论。