excel dates
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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
0 Commenti
Risposta accettata
Fangjun Jiang
il 21 Nov 2011
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 Commenti
Fangjun Jiang
il 21 Nov 2011
d is a char array, you could use d(1,:), or do a further conversion
e=cellstr(d); e{1}
Più risposte (1)
Walter Roberson
il 21 Nov 2011
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 Commenti
Walter Roberson
il 21 Nov 2011
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')
Vedere anche
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!