how to clear content of a sheet in excel

6 ビュー (過去 30 日間)
Nan Shen
Nan Shen 2012 年 3 月 6 日
回答済み: Jash Kadu 2022 年 7 月 14 日
Code is here:
Excel = actxserver('Excel.Application');
set(Excel, 'Visible', 1);
book = invoke(Excel.Workbooks,'Open',fileName);
curSheet = Excel.ActiveWorkbook.Sheets;
Sheets = Excel.Worksheets;
Rsheet = get(Sheets, 'Item', 'Result');
invoke(Rsheet, 'Activate');
Rsheet.Cells.Clear

サインインしてこの質問に回答する。

回答 (1 件)

Jash Kadu
Jash Kadu 2022 年 7 月 14 日
Hi!
Please find the attached documentation :
https://www.mathworks.com/discovery/matlab-excel.html
https://www.mathworks.com/help/simbio/ref/content.html?s_tid=answers_rc2-2_p5_MLT
You can also go through examples in them.
You can also go through the MATLAB answer : https://www.mathworks.com/matlabcentral/answers/42312-excel-clearing-sheet-content?s_tid=answers_rc1-2_p2_MLT

カテゴリ

Help Center および File Exchange で Install Products についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by