Import excel file destroy the date vector and convert them to numeric number

Question

Moshe 2016-8-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300129-import-excel-file-destroy-the-date-vector-and-convert-them-to-numeric-number

回答： Guillaume 2016-8-19

I am using matlab 2014a on Macintosh, when i am import Excel file into MATLAB the dates vector destroy and convert it to numeric number. when i do the same on PC the dates in the excel file stay the same as date and not destroy. what is the problem why there is different between the PC and the macintosh, and how i can fix it to work good on Macintosh.

code i am using:

File_Name ='SPX_Index.xlsx'; Load_DATA=dataset('XLSFIle',File_Name,'sheet',1);

thanks

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2016-8-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300129-import-excel-file-destroy-the-date-vector-and-convert-them-to-numeric-number#answer_232229

On a Windows computer with excel installed, matlab talks directly to excel to load the file. On a Windows computer without excel installed or on non-Windows computer this is not possible and a completely different method is used to load excel files. Matlab parses the file directly instead.

A downside of that is that indeed, excel dates are imported as excel serial date numbers. Here is a post on how to convert these numbers back to dates.