필터 지우기
필터 지우기

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 :
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 CenterFile Exchange에서 Install Products에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by