[solved] - xlsread on linux read dates as numbers

Question

yari lazzaro 2018-10-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/424066-solved-xlsread-on-linux-read-dates-as-numbers

评论： yari lazzaro 2018-10-16

采纳的回答： Walter Roberson

MSCIandFX.xlsx

在 MATLAB Online 中打开

Hi, I'm using xlsread to read the content of an .xlsx file

[data,text]=xlsread('MSCIandFX.xlsx','MSCIPI');

it sort of works but it's treating all the dates as numbers. I tried the same on a windows machine and the dates where treated as text and thus appeared under the data variable.

Can someone give their interpretation of what's going on and what's the best way to handle this situation?

edit: for example the date "12/31/1987" is imported in matlab as 32142 which is the same value I see on OpenOffice when converting that same date to text format in the xlsx file. I am attaching the file I'm using

Thanks

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2018-10-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/424066-solved-xlsread-on-linux-read-dates-as-numbers#answer_341526

This is documented. On Windows with Excel installed, MATLAB uses ActiveX to talk to excel, and has full functionality. Any other configuration is restricted to 'basic' mode.

You have a few choices:

there are routines in the Financial Toolbox or File Exchange to convert the numbers from Excel format to datenum
datetime() with 'convertfrom' excel options
use readtable() instead of xlsread, which in r2014b and later will automatically convert them to datetime objects.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

yari lazzaro 2018-10-16

Thank you Walter for pointing that out. The fastest way for me was to directly change the dates in the excel file and convert them to text, I will experiment with readtable() too as you suggested.

请先登录，再进行评论。