MATLAB: Reading time and dates from Excel

datesimporting excel data

Hey guys,

I have a problem using the xlsread function, in my spreadsheet,my dates are given in the following format:

So i used [numericData, stringData, allData] = xlsread(dataSource); But all the dates are in the string data is there a way that i can get those dates into the numericData?

Best Answer

Use datenum function

Related Solutions

MATLAB: I want to make date on output excel file.

 dateArray = xlsread('filename.xlxs','Sheet','A1:A100');

MATLAB: Failed to create PIL blocks

Hello,

It looks like you are looking at an older example using idelink_ert, which works with CCS 3.3.

Try looking at this example which should work better for CCSv6: http://www.mathworks.com/help/releases/R2016a/supportpkg/texasinstrumentsc2000/examples/code-verification-and-validation-with-pil.html

Best Answer

Related Solutions

MATLAB: I want to make date on output excel file.

MATLAB: Failed to create PIL blocks

Related Question