How can I delete a certain cell area in an Excel table using MATLAB 7.8 (R2009a)?
조회 수: 21 (최근 30일)
이전 댓글 표시
I would like to delete the existing values in a certain cell area of an Excel table using MATLAB.
채택된 답변
MathWorks Support Team
2009년 6월 27일
When XLSWRITE is used to write to cells in a spreadsheet, by default it overwrites the existing data in the cells. Thus deleting the existing values in a certain cell area can also be accomplished by writing empty cells.
The following example shows how to use the XLSWRITE command to write an empty cell to a cell area in order to clear the existing values:
xlswrite('test.xls', cell(29, 1), 'Table1', 'A3:A31');
댓글 수: 0
추가 답변 (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!