excel

1 次查看（过去 30 天）
ricco
ricco 2011-11-17
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:
1 instead 0f 01:00
2200 instead of 22:00
2100 instead of 21:00
...etc
Does anyone know of a way to convert this to give the correct values?
thanks
  2 个评论
Jan
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
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?

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson
Walter Roberson 2011-11-17
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by