Delete worksheet from Excel

1 回表示 (過去 30 日間)

Santosh Biradar 2022 年 8 月 8 日

閉鎖済み: dpb 2022 年 8 月 8 日

この質問は dpb さんによってフラグが設定されました

Hello

I have tried below

In the main code,

%%Value of newidx = "AAA" i,e, Excel Sheet Name

%% Value of excelName1 = D:\SANTOSH\Task2\Aug\NewSfun_SummaryResult\ABC.xlsx

After calling DeleteExcelSheets(excelName1, newidx) in the script.

I am expecting the sheet has to be deleted from theat excelName1.

function DeleteExcelSheets(excelName1, newidx)

try

Excel = actxserver('Excel.Application');

Workbooks = Excel.Workbooks;

Workbook = Workbooks.Open(excelName1);

Sheets = Excel.ActiveWorkBook.Sheets;

Sheets.Item(newidx).Delete;

end

Thank you

R2019b

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

Translated by