清空筛选条件
清空筛选条件

replicating dates and inporting them in an excel file

1 次查看（过去 30 天）
ektor
ektor 2012-5-18
HI all,
I want to replicate the dates '02/11/2008' '30/11/2008' so at to have
02/11/2008
30/11/2008
02/11/2008
'30/11/2008
So the repetition is every two elements. I apply the following code" dd=[{'02/11/2008' '30/11/2008'} ]';
B = dd(:,ones(4,1));
ss= B(:);
which seems to work but when i try to extract the variable ss in an excel file, then the output of the excel file is
39489
30/11/2008
39489
30/11/2008 39489
30/11/2008
39489
30/11/2008
39489
30/11/2008
Is there anything I can do to fix this problem?

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

采纳的回答

bym
bym 2012-5-18
change the format of the excel cell to 'date'. You can verify by entering formula in a cell =datevalue("2/11/2008") and the result is 39489
  1 个评论
ektor
ektor 2012-5-18
Thanks. It works. I was wondering if there is another way to fix it so as not to have to change the format of the excel cell to 'date'. I mean if it is possible to do that correction directly within matlab without having to do the modifications within excel.
Thanks again.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by