excel dates

2 次查看（过去 30 天）
ricco
ricco 2011-11-21
I understand that matlab cannot read excel dates in the sense that it changes hh:mm into decimals. This being said, is there a way of importing the dates as a string so that they would remain the same as in excel? I've tried using importdata and xlsread but neither seem to be able to!
cheers

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-11-21
Use [Num,Txt,Raw]=xlsread() and then "Raw" will keep the "hh:mm" string format, then you can use datenum() to convert it.
If the format of the cells in Excel is "Time", it looks like the numerical value is imported using xlsread(). You can use datestr() to convert it back. For example:
>> [Num,Txt,Raw]=xlsread('test.xls')
Num =
0.4743
0.5160
0.5576
0.5576
Txt =
'Date' 'Time'
'12/31/1899' ''
'1/1/1900' ''
'1/2/1900' ''
'1/3/1900' ''
Raw =
'Date' 'Time'
'12/31/1899' [0.4743]
'1/1/1900' [0.5160]
'1/2/1900' [0.5576]
'1/3/1900' [0.5576]
>> datestr(Num,'HH:MM')
ans =
11:23
12:23
13:23
13:23
  4 个评论
显示 2更早的评论
ricco
ricco 2011-11-21
that's great. How do I get to each of the time steps though? By 'get to' I mean say if
d=datestr(Num,'HH:MM')
d(1) would equal 11:23 instead at the moment d(1)=1 etc...
Fangjun Jiang
Fangjun Jiang 2011-11-21
d is a char array, you could use d(1,:), or do a further conversion
e=cellstr(d); e{1}

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2011-11-21
Warning: Excel represents numeric time data with a different time base than MATLAB does. There is a toolbox function that does the correction, http://www.mathworks.com/help/toolbox/finance/x2mdate.html, but you can code it yourself using the information referenced in my note in http://www.mathworks.com/matlabcentral/answers/254-converting-excel-serial-number-of-time-to-hh-mm-ss-format
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2011-11-21
datestr(datenum('2000-03-01 15:45:17','yyyy-mm-dd HH:MM:SS'):4/(60*24):datenum('2009-10-10 10:00:00','yyyy-mm-dd HH:MM:SS'),'yyyy-mm-dd HH:MM:SS')
ricco
ricco 2011-11-21
awesome.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by