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!