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