Info

此问题已关闭。 请重新打开它进行编辑或回答。

Delete worksheet from Excel

1 次查看（过去 30 天）
Santosh Biradar
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

此问题已关闭。

回答（0 个）

此问题已关闭。

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by