フィルターのクリア

how to clear content of a sheet in excel

16 ビュー (過去 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 :
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 ExchangeData Import from MATLAB についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by