how to combine datetime array with cell array for export?

2 visualizaciones (últimos 30 días)
roudan
roudan el 14 de Jul. de 2021
Comentada: roudan el 14 de Jul. de 2021
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

Respuesta aceptada

Stephen23
Stephen23 el 14 de Jul. de 2021
T = table(A,B);
writetable(T,...)
  1 comentario
roudan
roudan el 14 de Jul. de 2021
Yes it works perfectly. Thank you Stephen! I appreciate it. You saved me almost whole morning time.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Data Type Conversion en Help Center y File Exchange.

Productos


Versión

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by