xlsread problem with datenum

Question

Sal 2015-11-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/252196-xlsread-problem-with-datenum

评论： Sal 2015-11-1

Hi all,

When importing an xls file made of two columns: the first of timestamp and the second of value, I have an error doing the datenum on the timestamp cell. Indeed, the problem is how xlsread import the excel dates. In the last value you can see that the excel date '11/1/2015 00:00:00' is truncated and thus datenum do not find the correct format. Do you know how I can convert in a fast and easy way this format?

    '10/31/2015 11:59:29 PM'            [159510]
    '10/31/2015 11:59:34 PM'            [159527]
    '10/31/2015 11:59:42 PM'            [159528]
    '10/31/2015 11:59:43 PM'            [159536]
    '11/1/2015'                         [159537]

Thanks a lot

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2015-11-1

If you post the relevant part of the code, suggesting a modification is easier and more likely to match your needs.

请先登录，再进行评论。

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

Answer 1

Jan 2015-11-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/252196-xlsread-problem-with-datenum#answer_198101

在 MATLAB Online 中打开

You can append the trailing time string manually:

C = {'10/31/2015 11:59:29 PM'; ...
     '10/31/2015 11:59:34 PM'; ...
     '10/31/2015 11:59:42 PM'; ...
     '10/31/2015 11:59:43 PM'; ...
     '11/1/2015'};
Cropped = cellfun('length', C) < 10;
C(Cropped) = strcat(C(Cropped), {' 00:00:00 AM'});

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sal 2015-11-1

在 MATLAB Online 中打开

Thanks a lot Jan,

I was looking at the function generated by the wizard and actually a solution seems to be the handle that xlsread uses. In particular:

    [~, ~, raw, dates] = xlsread(workbookFile, sheetName, sprintf('A%d:B%d',startRow(1),endRow(1)),'' , @convertSpreadsheetExcelDates);

The function @convertSpreadsheetExcelDates seems to do this but I would like to not use the startRow and endRows because I do not know them before since all the files are different.

What do you think?

Thanks a lot

请先登录，再进行评论。