MATLAB: Convert date to datenum import from excel

importing excel dataMATLAB

hello

I want to import a simple excel file to matlab and convert the column with dates from text to numeric values. The problem is that the rule convert does not show up as an alternativ. I can only replace things. Would be very glad if someone could help.

Best Answer

I agree that readtable() is the better option but if you decide to stick with the import tool, here's an idea.

In the dropdown menu under your variable name 'dag' where it currently says "Number" in your screenshot, select a date and time option. This will convert your timestamps to datetime format. After importing, you can use datenum() to convert them to double if desired.

Here's a screen shot with a different data set.

Related Solutions

MATLAB: When using the import tool to import data from an excel file, how to convert the spreadsheet dates to datenumbers

To convert dates from spreadsheets to Date Number add a new rule for converting dates to Date Number. To add this rule:

1) Select “Convert” from drop down list in middle of the import window then Spreadsheets dates to->datenum from next dropdown lists.

2) Click “Import Selection” button this will import the selected data to the workspace in Date Numbers.

Please refer to following link for information on importing spreadsheet data:

http://www.mathworks.com/help/matlab/import_export/select-spreadsheet-data-interactively.html

MATLAB: How to use ‘textscan’ to read data from Sheet2 of an Excel file

Try

readtable( _______, 'DatetimeType', 'exceldatenum' );

See the documentation.

Best Answer

Related Solutions

MATLAB: When using the import tool to import data from an excel file, how to convert the spreadsheet dates to datenumbers

MATLAB: How to use ‘textscan’ to read data from Sheet2 of an Excel file

Related Question