clear;
e = actxserver('excel.application');
% Insert a new workbook.
% WorkBook=e.Workbooks.Open(path);
eWorkbook=e.Workbooks.Add;
% e.visible=1;
% Make the second sheet active.
% eActiveWorkbook = get(e, 'ActiveWorkBook');
% eSheets = get(eActiveWorkbook, 'Sheets');
eSheets = e.ActiveWorkBook.Sheets;
eSheets.Add;
eSheets.Item(1).Name = 'haha';
eSheets.Item(2).Name = 'hehe';
eSheets.Item(3).Name = 'OoOo';
% eSheet2 = Item(eSheets, 2);
eSheet2 =eSheets.Item(2);
% Rename the fault sheet 2.
eSheet2.name = 'new1';
% Activate(eSheet2);
eSheet2.Activate;
% Get a handle to the active sheet.
eActiveSheet = get(e, 'ActiveSheet');
% Put a MATLAB array into Excel.
A = [1 2; 3 4];
eActiveSheetRange = Range(eActiveSheet, 'A1:B2');
set(eActiveSheetRange, 'Value', A);
B=2*A;
%Make the Third sheet active
eSheet3 = Item(eSheets, 3);
Activate(eSheet3);
eActiveSheet = get(e, 'ActiveSheet');
eActiveSheetRange = Range(eActiveSheet, 'A4:B5');
set(eActiveSheetRange, 'Value', B);
% Now save the workbook
eWorkbook.SaveAs('F:\文档\MATLAB\test.xlsx');
e.Quit;
e.delete;
参考:
http://blog.csdn.net/lyfadd85/article/details/5874407
http://blog.sina.com.cn/s/blog_615d5f190100sv3n.html