how to read date time column in matlab

2 次查看（过去 30 天）
preeti visweswaran
preeti visweswaran 2017-4-18
评论： Peter Perkins 2017-4-26
My excel file contains datetime column in the format Sun Mar 5,16:06:17.66 How do I read the column along with the other numeric columns using xlsread. Attached in the snapshot of data.Unable to read Time column with xlsread

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

回答（1 个）

Peter Perkins
Peter Perkins 2017-4-18
Unless you're using a version of MATLAB older than about R2015a, use readtable, not xlsread. In recent versions, you'll get a datetime variable in the table automatically. In less recent versions, you'll get either a numeric (Excel serial date numbers) or a text variable in the table, depending on how the cells in the spreadsheet are formatted. In either case, call datetime on that table variable to get a datetime variable. For Excel date numbers, use 'ConvertFrom','excel'.
  3 个评论
显示 1更早的评论
preeti visweswaran
preeti visweswaran 2017-4-18
I get the error "Attempt to reference field of non-structure array."
Peter Perkins
Peter Perkins 2017-4-26
preeti, you will need to be more specific.

请先登录，再进行评论。

类别

在 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