how to delete the first sheet of an excel through script

hello, when i write some contents to excel file and add new sheet with specific name, i find sheet1 is still exist, how to delete it through script, thanks.

Answer 1

[Pavl M.]

Good question.

There are numerous options to do that complete.

Which Excel driver are there available to utilize for greater value?

Which OS are you on?

filepath = ... your file path;

sheetordernum = 1;

1.

newExcel = actxserver('excel.application');

excelWB = newExcel.Workbooks.Open(filepath,0,false);

newExcel.Visible = true;

newExcel.DisplayAlerts = false;

newExcel.Sheets.Item(sheetordernum).Delete;

excelWB.Save();

excelWB.Close();

newExcel.Quit();

clear excelWB

clear newExcel

2.

Excel = actxserver('Excel.Application');

Workbook = Excel.Workbooks.Open(strcat(pwd,'\MAT.xls'));

% Make the application invisible

set(Excel, 'Visible', 0);

% Make excel not display alerts

set(Excel,'DisplayAlerts',0);

% Get a handle to Excel's Workbooks

Workbooks = Excel.Workbooks;

Excel.ActiveWorkBook.Sheets.Item(sheetordernum).Delete;

Excel.Save()

Excel.Close()

3.

NET.addAssembly('microsoft.office.interop.excel');

app = Microsoft.Office.Interop.Excel.ApplicationClass;

app.Visible = true;

app.DisplayAlerts = false;

app.ActiveWorkBook.Sheets.Item(sheetodernum).Delete;

app.Save()

app.Close()

clear app

Hope this finds you well and solves the problem.

[wenchao zhang]

thank you,seems little complex