bouts_data = [datenum(raw_bouts_data(2:end,5), 'dd/mm/yyyy HH:MM:SS PM'), ... datenum(raw_bouts_data(2:end,6), 'dd/mm/yyyy HH:MM:SS PM'), ... cell2mat(raw_bouts_data(2:end,7:end))]; * Error in DataLogger_DailyBouts (line 36) bouts_data = [datenum(raw_bouts_data(2:end,5), 'dd/mm/yyyy HH:MM:SS PM'), ... Caused by: Error using datenum (line 107) The input to DATENUM was not an array of strings.* I'm trying to read an excel file and I get this error why? How to fix it?

Datenum error..how to fix

Yasaman Best

2017 7 11

0 个回答

3 次查看（30 天）

0 个投票

    bouts_data = [datenum(raw_bouts_data(2:end,5), 'dd/mm/yyyy HH:MM:SS PM'), ...
          datenum(raw_bouts_data(2:end,6), 'dd/mm/yyyy HH:MM:SS PM'), ...
          cell2mat(raw_bouts_data(2:end,7:end))];

Error in DataLogger_DailyBouts (line 36) bouts_data = [datenum(raw_bouts_data(2:end,5), 'dd/mm/yyyy HH:MM:SS PM'), ...

Caused by: Error using datenum (line 107) The input to DATENUM was not an array of strings.*

I'm trying to read an excel file and I get this error why? How to fix it?

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

Robert U 2017-7-18

在 MATLAB Online 中打开

Hi, my first guess would be that you read your Excel sheet by utilizing

[num,txt,raw] = xlsread(___)

where your output raw_bouts_data is representing the "raw"-output from xlsread().

Writing now raw_bouts_data(2:end,5) gives you a cell whereas you need a string:

[datenum(raw_bouts_data{2:end,5}, 'dd/mm/yyyy HH:MM:SS PM'), ...
        datenum(raw_bouts_data{2:end,6}, 'dd/mm/yyyy HH:MM:SS PM'), ...
        cell2mat(raw_bouts_data(2:end,7:end))];

Kind regards,

Robert Uhlig

请先登录，再进行评论。

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

Follow Question