I wnat to import date in excel file.

1 visualización (últimos 30 días)
Jeong_evolution
Jeong_evolution el 1 de Jul. de 2016
Comentada: Jeong_evolution el 29 de Oct. de 2016
Hello.
I have a problem imported excel file.
When I import excel data, Others is imported in MATLAB.
But Date & Time isn't imported in MATLAB.
1.JPG is raw data.
2.JPG is picture after importing.
I want to insert Date & Time on 1c olumn in 2.JPG
And also insert Date,Time, 1.풍향, 2.풍속 .... on 1 row.
What should I do?
Plus, When I export 2.JPG, also want to export Date & TIme and so on. (in 1row, 1column)
Please help me.

Respuesta aceptada

Walter Roberson
Walter Roberson el 1 de Jul. de 2016
I recommend that you use readtable() if you have R2014b or later, as it can will convert excel dates into datetime objects during the importing.

Más respuestas (1)

Tien Tran
Tien Tran el 1 de Jul. de 2016
You can use a syntax:
[num txt raw] = xlsread('yourexceldocument.xls')

Categorías

Más información sobre Data Import and Analysis en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by