xlswrite Issue: not writing an entire column

5 visualizaciones (últimos 30 días)
Carolyn
Carolyn el 7 de En. de 2019
Editada: dpb el 8 de En. de 2019
I have this dataset that I have done all sorts of analysis on and I've compiled it into this matrix and want to write it to an excel file. Thought that would be easy.
I just used the following:
xlswrite('Data.xlsx',data)
But when I open the new excel file, the entire first column is blank. The 'LEK_01' (or other subject ID) is just not there. Any idea why that is? I checked format of all the entries in the cells and they are all in agreement. I'm not getting any errors either.
Thanks in advance!
  2 comentarios
nanren888
nanren888 el 7 de En. de 2019
Editada: nanren888 el 7 de En. de 2019
Example of first few rows of "data"?
Carolyn
Carolyn el 7 de En. de 2019
This (attached) was attached to my original question. Are you having trouble seeing it?

Iniciar sesión para comentar.

Respuestas (1)

dpb
dpb el 7 de En. de 2019
Editada: dpb el 8 de En. de 2019
The first column of data is a column of cells each containing a cell containing...
xlswrite can't handle that.
data(:,1)=data{:,1}; % recast the cells to the cellstrings
xlswrite('Data.xlsx',data) % will work now

Etiquetas

Productos


Versión

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by