Multi-Delimited file

Question

0 个投票

I have data in xls files and one of the rows looks like this: 1/1/09 0:21 The first have represents date and the second have represents time. when imported using xlsread is get a long number which means nothing I need the date and the time. Can some one help me please.

2 个评论
显示无隐藏无

Paulo Silva 2011-3-5

post the code you are using and someone might tell you what your should improve or change.

faisal Mahmood 2011-3-5

for i = 1:numberoffiles

A = 'Data';

str = sprintf('%d',i);

varname = [A,str];

filename = listing(i,:).name;

[ndata, text, alldata]= xlsread(filename);

end

Follow Question

Answer 1

Walter Roberson 2011-3-5

2 个投票

datestr() that long number. But be sure to cross-check the result, as excel's time base is different than Matlab's. There is a relatively simple time conversion if needed. The offsets are documented here

2 个评论
显示无隐藏无

faisal Mahmood 2011-3-5

what about if its in the middle of the file. Like it row number T.

Walter Roberson 2011-3-5

Then datestr(ndata(T,C)) where C is the column number.

Multi-Delimited file

2 个评论
显示无隐藏无

回答（1 个）

2 个评论
显示无隐藏无

标签

Community Treasure Hunt

Multi-Delimited file

2 个评论 显示 无 隐藏 无

回答（1 个）

2 个评论 显示 无 隐藏 无

标签

另请参阅

Community Treasure Hunt

2 个评论
显示无隐藏无

2 个评论
显示无隐藏无