Convert string array to cell

Question

I need to output a cell to an excel file. Before this I need to convert a date column of integers to datestrings. I know how to do this, but I am not able to put this new string array back into the cell -

mycell = { 'AIR' [780] [1] [734472] [0.01] ; ...
           'ABC' [780] [1] [734472] [0.02]}

I did this -->

dates = datestr(cell2mat(mycell(:,4))) ;

What I need as an answer is:

{'AIR' [780] [1] '14-Dec-2010' [0.01] ;
 'ABC' [780] [1] '23-Dec-2010' [0.03] ; }

so that I can now send it to an excel file using xlswrite.m

zellus · Accepted Answer · 2010-12-30 16:34:26Z

3

mycell = { 'AIR' 780 1 734472 0.01] ; ...
           'ABC' 780 1 734472 0.02]}

mycell(:,4) = cellstr(datestr(cell2mat(mycell(:,4))))

mycell = 

    'AIR'    [780]    [1]    '30-Nov-2010'    [0.01]
    'ABC'    [780]    [1]    '30-Nov-2010'    [0.02]

answered Dec 30, 2010 at 16:34

zellus

9,5825 gold badges41 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gnovice · Accepted Answer · 2010-12-30 17:12:16Z

1

One alternative that avoids the conversions is to use the function CELLFUN:

mycell(:,4) = cellfun(@datestr,mycell(:,4),'UniformOutput',false);
%# Or an alternative format...
mycell(:,4) = cellfun(@(d) {datestr(d)},mycell(:,4));

Both of the above give the following result for your sample cell array:

mycell = 

    'AIR'    [780]    [1]    '30-Nov-2010'    [0.0100]
    'ABC'    [780]    [1]    '30-Nov-2010'    [0.0200]

answered Dec 30, 2010 at 17:12

gnovice

126k16 gold badges259 silver badges364 bronze badges

Collectives™ on Stack Overflow

Convert string array to cell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related