Info
この質問は閉じられています。 編集または回答するには再度開いてください。
How to import an excel file that contains an absolute time column?
1 回表示 (過去 30 日間)
古いコメントを表示
I have a file that contains some data and one of the colums is in absolute time format. I am using the xlsread function but the issue is that it won't show the date but only NaN values on that column (2nd column)
Any hints on how to do so?
here is my code so far
xlsread ECUSIMTEST0000-000-01.csv
for k=1:size(ans,2)
ans(:,k) = fillmissing(ans(:,k),"previous")
end
![test.PNG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/261931/test.png)
This is the actual data I recorded.
![matlabview.PNG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/261932/matlabview.png)
and this is how it shows in matlab. Also, is there a way to show the values without the scale?
Thanks!!!
0 件のコメント
回答 (3 件)
stozaki
2020 年 1 月 15 日
Hello
Please define a return value of xlsread. for example..
[~,~,raw] = xlsread('ECUSIMTEST0000-000-01.csv')
raw =
13×3 cell array
{'Time ' } {'Absolute Time'} {'Engine Speed'}
{'s' } {'DateTime' } {'RPM' }
{[ 300]} {'2019/12/20' } {[ 1000]}
{[300.1000]} {'2019/12/21' } {[ 1000]}
{[300.2000]} {'2019/12/22' } {[ 1000]}
{[300.3000]} {'2019/12/23' } {[ 1000]}
{[300.4000]} {'2019/12/24' } {[ 1000]}
{[300.5000]} {'2019/12/25' } {[ 1000]}
{[300.6000]} {'2019/12/26' } {[ 1000]}
{[300.7000]} {'2019/12/27' } {[ 1000]}
{[300.8000]} {'2019/12/28' } {[ 1000]}
{[300.9000]} {'2019/12/29' } {[ 1000]}
{[ 301]} {'2019/12/30' } {[ 1000]}
Regards,
stozaki
2 件のコメント
stozaki
2020 年 1 月 15 日
Hi,
In Excel, dates are strings. So I think you can only get dates as strings.
![dateTime.png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/261965/dateTime.png)
Diego Dranuta
2020 年 1 月 15 日
1 件のコメント
stozaki
2020 年 1 月 15 日
編集済み: stozaki
2020 年 1 月 16 日
Hello, Diego
Can you remove '/' slash and ':' colon from date data? Sslash and colon aren't numeric. They are string.
Numeric characters can be converted to double type with str2double, but simple characters cannot be converted to double type.
If you convert a simple character to double, it will be Nan.
Regards,
stozaki
Diego Dranuta
2020 年 1 月 16 日
1 件のコメント
stozaki
2020 年 1 月 21 日
Why don't you edit with the MATLAB program?
date1 = '2020/01/01';
tmpData1 = replace(date1,'/','');
date1 = str2double(tmpData1)
date =
20200101
この質問は閉じられています。
参考
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!