使用matlab的xlswrite时如何删除默认的sheet1和sheet2和sheet3?
(2017-08-03 14:07:19)
标签:
xlswritematlabsheet删除 |
分类: MatLab |
来源:
How can I delete the default sheets Sheet1,
Sheet2 and Sheet3 in Excel, when I use XLSWRITE?
%
Throws an error if the sheets do not exist.
objExcel.ActiveWorkbook.Worksheets.Item([sheetName
'1']).Delete;
objExcel.ActiveWorkbook.Worksheets.Item([sheetName
'2']).Delete;
objExcel.ActiveWorkbook.Worksheets.Item([sheetName
'3']).Delete;
; %
Do nothing.
问题:
答案:
You can delete the sheets that get created automatically by
Excel when you use XLSWRITE with a new file name by
using
ActiveX functionality (Windows only).
-----------------------
Example:
excelFileName = 'Test.xls';
excelFilePath = pwd; % Current working directory.
sheetName = 'Sheet'; % EN: Sheet, DE: Tabelle, etc. (Lang.
dependent)
% Open Excel file.
objExcel = actxserver('Excel.Application');
objExcel.Workbooks.Open(fullfile(excelFilePath,
excelFileName)); % Full path is necessary!
% Delete sheets.
try
catch
end
% Save, close and clean up.
objExcel.ActiveWorkbook.Save;
objExcel.ActiveWorkbook.Close;
objExcel.Quit;
objExcel.delete;