Write cells to individual excel sheets
조회 수: 1 (최근 30일)
이전 댓글 표시
Hi, I'm having problems writting individual cells to individual sheets in excel. It states an invalid data range. I need to add the cell IDs above the orginal data.
Attached is the code for xlswrite.
Thanks
Load('Sample_data.mat');
Fnane = 'PD.xlsx';
%add cell ID above PD data for each cell.
for n = 1:numel(Sheet_names)
PD_adpt{n}(2,:) = PD_adpt{n}(1,:);
PD_adpt{n}(1,:) = Cell_ID;
end
for ii = 1:numel(PD_adpt)
xlswrite(Fnane,PD_adpt{ii},'sheet',sheet_names(ii))
end
댓글 수: 3
답변 (1개)
Dave B
2021년 11월 4일
편집: Dave B
2021년 11월 5일
xlswrite(Fnane, PD_adpt{ii}, sheet_names(ii))
But in general you might have a better time if you use writematrix/writecell/writetable instead of xlswrite
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!