Delete worksheet from Excel

2022 8 8
0 个回答
更新时间：2022 8 8
6 次查看（30 天）

0 个投票

此 个问题 已被 dpb 标记
  • 由 dpb 在 2022-8-8 标记为 重复。
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

标签

关闭：

dpb
dpb
2022-8-8

Community Treasure Hunt

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

Start Hunting!

Translated by