how to combine datetime array with cell array for export?

Hi
I have one 1000 by 1 string cell array and one 1000 by 1 datetime array. I'd like to combine them together so export. Here is the code I have
A=datetime(datestr(wellcyclestartdate,'yyyy-mm-dd'));
A look like this:
Jan 1 2000
Jan 2 2000
...
Jan 1 2021
B look like this:
{'A1}
{'A2'}
.....
{'A1000'}
Then, I combine them together using below
export={B,A}
writecell(export,export_filename,'QuoteStrings',true) ;
I got an error of Nested cell arrays are not supported. I am thinking maybe I need to convert B cell array to text array? Any suggestion? Thanks

 Accepted Answer

T = table(A,B);
writetable(T,...)

1 Comment

Yes it works perfectly. Thank you Stephen! I appreciate it. You saved me almost whole morning time.

Sign in to comment.

More Answers (0)

Categories

Products

Release

R2020a

Asked:

on 14 Jul 2021

Commented:

on 14 Jul 2021

Community Treasure Hunt

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

Start Hunting!