MATLAB: Excel COM Server, create Autofilter

activexautofilterexcel

Hi, I'm writing a script starting an Excel COM-Server and inserting some data into a sheet. This is works fine but in addition I'm searching for a command to create an Autofilter for a selected Row.

Does anyone know how I can achieve this? I'm searching for a function reference as I'm not very familiar with COM/ActiveX etc. (I also want to fix my window on a certain cell…)

Any help is welcome 🙂

Best Answer

Hi,

A good way to get the function and command you need it to open Excel and let EXCEL record a macro for you. Simply click on start recording macro, do manually what you like to do in EXCEL and hit stop recording. After recording is done you can look at the VB code which gives you all needed functions and commands.

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: How to merge cells in excel

Check here .

e = actxserver('Excel.Application');
% Add a workbook.
eWorkbook = e.Workbooks.Add;
e.Visible = 1;
% Make the first sheet active.
eSheets = e.ActiveWorkbook.Sheets;
eSheet1 = eSheets.get('Item',1);
eSheet1.Activate
% Merge Cells
eSheet1 = eSheet1.get('Range', 'A1:E1');
eSheet1.MergeCells = 1;
eSheet1.Value = 'text here';
eSheet1.Font.ColorIndex = 3
eSheet1.Font.Bold = 1;

Best Answer

Related Solutions

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

MATLAB: How to merge cells in excel

Related Question