MATLAB: Problem on acessing excel by activeX command in Matlab

activexexcelMATLABobjectworksheets

I tested code below

Excel = actxserver('Excel.Application');
set(Excel,'Visible',1);
Workbooks = Excel.Workbooks.Open('C:\Users\Bibi\Documents\MATLAB\New Microsoft Excel Worksheet.xlsx');  
Excel.Worksheets.Add

Then I found I successfully added a new sheet "sheet2" before "sheet1"

But I searched for excel objects in http://msdn.microsoft.com/en-us/library/office/ff821537(v=office.15).aspx

Actually, one can arrange the order of the sheet by adding count and before just as below,

Worksheets.Add *Count:=2, Before:=Sheets(1)

But how to add "Count" and "Before" in matlab language, I tried many times but all failed.

Best Answer

Have you tried the below link: http://www.mathworks.com/matlabcentral/answers/2603-add-a-new-excel-sheet-from-matlab

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Add a new Excel sheet from Matlab

According to the VBA documentation on MSDN, to add after the active sheet, specify the active sheet as the second argument to the Add method:

Worksheet.Sheets.Add([], ActiveSheet)

Here's an example that adds a new sheet after the last worksheet (example assumes an Excel file called "Book1.xlsx" in the current folder):

% Connect to Excel
Excel = actxserver('excel.application');
% Get Workbook object
WB = Excel.Workbooks.Open(fullfile(pwd, 'Book1.xlsx'), 0, false);
% Get Worksheets object
WS = WB.Worksheets;
% Add after the last sheet
WS.Add([], WS.Item(WS.Count));
% Save
WB.Save();
% Quit Excel
Excel.Quit();

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Add a new Excel sheet from Matlab

Related Question