清空筛选条件
清空筛选条件

Import excel file with comma for decimal and dates

2 次查看（过去 30 天）
Jenny
Jenny 2014-2-6
评论： Tamara del Águila 2020-3-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.

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

回答（1 个）

Jos (10584)
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 个评论
显示 1更早的评论
Ilham Hardy
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
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!

Translated by