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.
