xlswrite Issue: not writing an entire column

조회 수: 3 (최근 30일)
Carolyn
Carolyn 2019년 1월 7일
편집: dpb 2019년 1월 8일
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
nanren888
nanren888 2019년 1월 7일
편집: nanren888 2019년 1월 7일
Example of first few rows of "data"?
Carolyn
Carolyn 2019년 1월 7일
This (attached) was attached to my original question. Are you having trouble seeing it?

댓글을 달려면 로그인하십시오.

답변 (1개)

dpb
dpb 2019년 1월 7일
편집: dpb 2019년 1월 8일
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

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

제품


릴리스

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by