xlsread is importing the date strings as a serial date in my mac script but not on my windows script

Question

Thomas 2015-12-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/262260-xlsread-is-importing-the-date-strings-as-a-serial-date-in-my-mac-script-but-not-on-my-windows-script

评论： Thomas 2016-2-11

I've been writing a script on my mac using matlab R2015b (same version on windows) to import a large spreadsheet and it imports fine on my mac with the date strings converted to serial number. When I load the same script to my windows OS it will not read the date strings nor convert them. I have tried several way around [num, txt, raw] and and manipulating it that way however, I have found that the date vector has been very odd and was thinking there might be some setting that is awry.

If anyone can help that would be much appreciated.

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

Walter Roberson 2015-12-30

I wonder if you could extract a small portion and post the file? Say one column with the date and one column with numeric, and perhaps 3 rows.

请先登录，再进行评论。

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

Answer 1

Jon Brenner 2016-1-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/262260-xlsread-is-importing-the-date-strings-as-a-serial-date-in-my-mac-script-but-not-on-my-windows-script#answer_205074

编辑：Jon Brenner 2016-1-6

在 MATLAB Online 中打开

Hi Thomas,

xlsread behaves differently on Macs than on Windows. I think what you need is xlsread's 'basic' mode. 'basic' mode will return Excel serial date numbers on all platforms.

>> [num, txt, raw] = xlsread('myfile.xlsx', 1, '', 'basic');

Call "help xlsread" or "doc xlsread" for more details on how to use xlsread.