Export Data from a Structure which contains double timeseries data to Excel ... Example Data Provided...

Question

Aqib Idrees 2017-10-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/361766-export-data-from-a-structure-which-contains-double-timeseries-data-to-excel-example-data-provide

评论： Cedric 2020-7-29

采纳的回答： Cedric

CarData.mat

Hello,

I have:

Struct named 'CarData', contains double timeseries fields, named 'Left' and 'Right' each has with 20 columns and over 10-20,000 rows.

I wish to run a script to export CarData.Left into an new Excel sheet (xlswrite('something.xlsx'), I've read various pages of help and am struggling to address the data fields inside as well as extracting all 20 columns.

Can someone please facilitate, having the field names if of no importance. I only need the numerical data without concatenating vertically/horizontally.

Here are some of the pages I've looked into: https://uk.mathworks.com/matlabcentral/answers/278751-how-to-extract-data-from-structure-efficiently https://uk.mathworks.com/matlabcentral/fileexchange/22510-struc2xls https://stackoverflow.com/questions/25948371/how-to-write-a-structure-to-excel-in-matlab struct2cell etc

I'm in need to do with without the use of plug-ins, I've attached an example version of the MATLAB struc to help understand what I have.

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

请先登录，再进行评论。

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

Answer 1

Cedric 2017-10-17

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/361766-export-data-from-a-structure-which-contains-double-timeseries-data-to-excel-example-data-provide#answer_286234

编辑：Cedric 2017-10-17

在 MATLAB Online 中打开

Here is one way if you want to create two worksheets "Left" and "Right" in the same workbook, with 21 column per sheet for time and data:

 xlswrite( 'CarData.xlsx', [CarData.Left.Time, CarData.Left.Data], 'Left' ) ;
 xlswrite( 'CarData.xlsx', [CarData.Right.Time, CarData.Right.Data], 'Right' ) ;

4 个评论
显示 2更早的评论隐藏 2更早的评论

Ilaria Shireen Sestili 2020-7-29

Hello,

I have tried as said but exporting them to excel I obtain many inconsistencies with the data, meaning that excel doesn't read the . separator and I get in some cells 1227 instead of 12.27 for example,but not in all of them.

does anyone now how to solve this problem?

thanks a lot!