Import excel file with comma for decimal and dates
조회 수: 2 (최근 30일)
이전 댓글 표시
I have an excel file of dates and water level data (attached).
The dates are in format: dd/mm/yyyy hh:mm:ss.
The water level format uses a comma as the decimal point.
When I use the import tool in Matlab I am unable to import the data as 'dates' and a column of 'water levels'.
How do I import the file so that the first column is read in as a date and the second column as the data?
I would like to plot the water level data with the date along the x-axis.
I can manually change the comma to a 'fullstop' before I import the file but I am sure that there is a way to do this without me manually editing the file beforehand.
댓글 수: 2
답변 (1개)
Jos (10584)
2014년 2월 6일
In excel and/or in Windows System settings (i do not know where) change the settings of the decimal notation to dot and to the required date-time format.
After successful import, get rid of excel and windows … ;-)
댓글 수: 3
Ilham Hardy
2014년 2월 6일
Start >> Control Panel >> Change keyboards or other input methodes >> "Formats" Tab >> Additional Settings >> "Numbers" Tab >> Change decimal symbol to dot.
You need to restart excel for the change to take effect
Tamara del Águila
2020년 3월 30일
That means there is no way of doing it from Matlab?
I agree excel and windows are insufferable, but I didn't expect this from Matlab. What a dissapointment...
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!