XLL+ Class Library

CXllCom Methods

The methods of the CXllCom class are listed here.

Construction etc

public methodCXllComConstructs a CXllCom object
public methodInitInitialise the CXllCom object
public methodTermTerminates a connection to Excel's COM interface

Shortcuts

public methodOleGetWorkbooksGet the Application.Workbooks collection
public methodOleGetWorkbookGet a member of the Application.Workbooks collection by name
public methodOleGetWorksheetsGet the Worksheets collection for a named workbook
public methodOleGetWorksheetGet a Worksheet by name
public methodOleGetRangeGet a Range

Properties

public methodOleGetWarningsGet the value of Application.DisplayAlerts
public methodOleSetWarningsSet the value of Application.DisplayAlerts
public methodOleGetOnSheetActivateGet the value of Application.OnSheetActivate
public methodOleSetOnSheetActivateSet the value of Application.OnSheetActivate
public methodOleGetOnSheetDeactivateGet the value of Application.OnSheetDeactivate
public methodOleSetOnSheetDeactivateSet the value of Application.OnSheetDeactivate
public methodOleGetOnCalculateGet the value of Application.OnCalculate
public methodOleSetOnCalculateSet the value of Application.OnCalculate
public methodpublic methodOleGetRangeFormulaGet the value of Range.Formula
public methodpublic methodOleGetRangeValueGet the value of Range.Value
public methodpublic methodOleGetRangeAddressGet the value of Range.Address
public methodpublic methodOleGetRangeWorksheetGet the value of Range.Worksheet
public methodpublic methodOleGetWorksheetWorkbookGet the value of Worksheet.Parent
public methodpublic methodOleGetWorkbookNameGet the name of a workbook
public methodpublic methodOleGetWorksheetNameGet the name of a worksheet

Search

public methodpublic methodOleWorksheetFindFormulaSearch for an instance of a formula in a worksheet
public methodpublic methodOleRangeIsFirstReturns whether range is the first (or only) cell of an array
public methodpublic methodOleRangeIsCurrentGet the value of Range.Address = Range.CurrentArray.Address

Operations

public methodOleExecuteExcel4MacroCall Application.ExecuteExcel4Macro
public methodpublic methodOleTouchRangeForce a range to recalculate

Requirements

Header: xlpcom.h

See Also

CXllCom Class | xlpcom.h | CXllApp::SetSinkEvents()