how to combine datetime array with cell array for export?

2 views (last 30 days)
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

Stephen23
Stephen23 on 14 Jul 2021
T = table(A,B);
writetable(T,...)
  1 Comment
roudan
roudan on 14 Jul 2021
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

Find more on Data Type Conversion in Help Center and File Exchange

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!