I wnat to import date in excel file.

2 visualizzazioni (ultimi 30 giorni)
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.

Risposta accettata

Walter Roberson
Walter Roberson il 1 Lug 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.

Più risposte (1)

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

Community Treasure Hunt

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

Start Hunting!

Translated by