excel
2 次查看(过去 30 天)
显示 更早的评论
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
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.
回答(1 个)
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.
0 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!