xlswrite Issue: not writing an entire column

2 visualizzazioni (ultimi 30 giorni)
Carolyn
Carolyn il 7 Gen 2019
Modificato: dpb il 8 Gen 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 Commenti
nanren888
nanren888 il 7 Gen 2019
Modificato: nanren888 il 7 Gen 2019
Example of first few rows of "data"?
Carolyn
Carolyn il 7 Gen 2019
This (attached) was attached to my original question. Are you having trouble seeing it?

Accedi per commentare.

Risposte (1)

dpb
dpb il 7 Gen 2019
Modificato: dpb il 8 Gen 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

Tag

Prodotti


Release

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by