excel

Question

ricco 2011-11-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21514-excel

In order to get an excel worksheet into matlab I have used the following:

files = dir('*.xls');

for i=1:length(files);

    File_Name{i}=files(i,1).name;%Removes the file names from %'files'
    [num{i},txt,raw] = xlsread(File_Name{i},'Ble min');
end

Which takes the worksheet 'Ble min' from each spreadsheet I have in a folder.

However, the time column is in the following format:

  instead 0f 01:00
instead of 22:00 
instead of 21:00
...etc

Does anyone know of a way to convert this to give the correct values?

thanks

2 个评论
显示无隐藏无

Jan 2011-11-17

Are you sure that "01:00" is converted to [1], but "22:00" is converted to [2200]? This does not look consistent.

ricco 2011-11-17

Sorry I worte that wrong, the column is in hhmm so 1 would actually be 00:01. Is there any way of conveting them?

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2011-11-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/21514-excel#answer_28331

Your input loop is storing the "num" output of xlsread, but not the "txt" output. Depending exactly how that column was stored in Excel, you will either get the internal Excel time representation or an interpretation of "01:00" (and so on) in to integer form.

You cannot retrieve a colon-delimited time in a numeric column: numeric matrices are not able to store the ':' character.