xlswrite Issue: not writing an entire column

2 Ansichten (letzte 30 Tage)
Carolyn
Carolyn am 7 Jan. 2019
Bearbeitet: dpb am 8 Jan. 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 Kommentare
nanren888
nanren888 am 7 Jan. 2019
Bearbeitet: nanren888 am 7 Jan. 2019
Example of first few rows of "data"?
Carolyn
Carolyn am 7 Jan. 2019
This (attached) was attached to my original question. Are you having trouble seeing it?

Melden Sie sich an, um zu kommentieren.

Antworten (1)

dpb
dpb am 7 Jan. 2019
Bearbeitet: dpb am 8 Jan. 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

Tags

Produkte


Version

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by