xlswrite Issue: not writing an entire column

2 views (last 30 days)
Carolyn
Carolyn on 7 Jan 2019
Edited: dpb on 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 Comments
nanren888
nanren888 on 7 Jan 2019
Edited: nanren888 on 7 Jan 2019
Example of first few rows of "data"?
Carolyn
Carolyn on 7 Jan 2019
This (attached) was attached to my original question. Are you having trouble seeing it?

Sign in to comment.

Answers (1)

dpb
dpb on 7 Jan 2019
Edited: dpb on 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

Products


Release

R2018b

Community Treasure Hunt

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

Start Hunting!