Reference

The COM object is a QAxObject with the CLSID .

Interfaces

Event Interfaces

Public Slots:

Signals:

Properties:


Member Type Documentation

Constants

XlAboveBelow

XlActionType

XlAllocation

XlAllocationMethod

XlAllocationValue

XlApplicationInternational

XlApplyNamesOrder

XlArabicModes

XlArrangeStyle

XlArrowHeadLength

XlArrowHeadStyle

XlArrowHeadWidth

XlAutoFillType

XlAutoFilterOperator

XlAxisCrosses

XlAxisGroup

XlAxisType

XlBackground

XlBarShape

XlBorderWeight

XlBordersIndex

XlBuiltInDialog

XlCVError

XlCalcFor

XlCalcMemNumberFormatType

XlCalculatedMemberType

XlCalculation

XlCalculationInterruptKey

XlCalculationState

XlCategoryLabelLevel

XlCategoryType

XlCellChangedState

XlCellInsertionMode

XlCellType

XlChartElementPosition

XlChartGallery

XlChartItem

XlChartLocation

XlChartPicturePlacement

XlChartPictureType

XlChartSplitType

XlChartType

XlCheckInVersionType

XlClipboardFormat

XlCmdType

XlColorIndex

XlColumnDataType

XlCommandUnderlines

XlCommentDisplayMode

XlConditionValueTypes

XlConnectionType

XlConsolidationFunction

XlContainsOperator

XlCopyPictureFormat

XlCorruptLoad

XlCreator

XlCredentialsMethod

XlCubeFieldSubType

XlCubeFieldType

XlCutCopyMode

XlDVAlertStyle

XlDVType

XlDataBarAxisPosition

XlDataBarBorderType

XlDataBarFillType

XlDataBarNegativeColorType

XlDataLabelPosition

XlDataLabelSeparator

XlDataLabelsType

XlDataSeriesDate

XlDataSeriesType

XlDeleteShiftDirection

XlDirection

XlDisplayBlanksAs

XlDisplayDrawingObjects

XlDisplayUnit

XlDupeUnique

XlDynamicFilterCriteria

XlEditionFormat

XlEditionOptionsOption

XlEditionType

XlEnableCancelKey

XlEnableSelection

XlEndStyleCap

XlErrorBarDirection

XlErrorBarInclude

XlErrorBarType

XlErrorChecks

XlFileAccess

XlFileFormat

XlFileValidationPivotMode

XlFillWith

XlFilterAction

XlFilterAllDatesInPeriod

XlFilterStatus

XlFindLookIn

XlFixedFormatQuality

XlFixedFormatType

XlFormControl

XlFormatConditionOperator

XlFormatConditionType

XlFormatFilterTypes

XlFormulaLabel

XlGenerateTableRefs

XlGradientFillType

XlHAlign

XlHebrewModes

XlHighlightChangesTime

XlHtmlType

XlIMEMode

XlIcon

XlIconSet

XlImportDataAs

XlInsertFormatOrigin

XlInsertShiftDirection

XlLayoutFormType

XlLayoutRowType

XlLegendPosition

XlLineStyle

XlLink

XlLinkInfo

XlLinkInfoType

XlLinkStatus

XlLinkType

XlListConflict

XlListDataType

XlListObjectSourceType

XlLocationInTable

XlLookAt

XlLookFor

XlMSApplication

XlMailSystem

XlMarkerStyle

XlMeasurementUnits

XlModelChangeSource

XlMouseButton

XlMousePointer

XlOLEType

XlOLEVerb

XlOartHorizontalOverflow

XlOartVerticalOverflow

XlObjectSize

XlOrder

XlOrientation

XlPTSelectionMode

XlPageBreak

XlPageBreakExtent

XlPageOrientation

XlPaperSize

XlParameterDataType

XlParameterType

XlPasteSpecialOperation

XlPasteType

XlPattern

XlPhoneticAlignment

XlPhoneticCharacterType

XlPictureAppearance

XlPictureConvertorType

XlPieSliceIndex

XlPieSliceLocation

XlPivotCellType

XlPivotConditionScope

XlPivotFieldCalculation

XlPivotFieldDataType

XlPivotFieldOrientation

XlPivotFieldRepeatLabels

XlPivotFilterType

XlPivotFormatType

XlPivotLineType

XlPivotTableMissingItems

XlPivotTableSourceType

XlPivotTableVersionList

XlPlacement

XlPlatform

XlPortugueseReform

XlPrintErrors

XlPrintLocation

XlPriority

XlPropertyDisplayedIn

XlProtectedViewCloseReason

XlProtectedViewWindowState

XlQueryType

XlQuickAnalysisMode

XlRangeAutoFormat

XlRangeValueDataType

XlReferenceStyle

XlReferenceType

XlRemoveDocInfoType

XlRgbColor

XlRobustConnect

XlRoutingSlipDelivery

XlRoutingSlipStatus

XlRowCol

XlRunAutoMacro

XlSaveAction

XlSaveAsAccessMode

XlSaveConflictResolution

XlScaleType

XlSearchDirection

XlSearchOrder

XlSearchWithin

XlSeriesNameLevel

XlSheetType

XlSheetVisibility

XlSizeRepresents

XlSlicerCacheType

XlSlicerCrossFilterType

XlSlicerSort

XlSmartTagControlType

XlSmartTagDisplayMode

XlSortDataOption

XlSortMethod

XlSortMethodOld

XlSortOn

XlSortOrder

XlSortOrientation

XlSortType

XlSourceType

XlSpanishModes

XlSparkScale

XlSparkType

XlSparklineRowCol

XlSpeakDirection

XlSpecialCellsValue

XlStdColorScale

XlSubscribeToFormat

XlSubtototalLocationType

XlSummaryColumn

XlSummaryReportType

XlSummaryRow

XlTabPosition

XlTableStyleElementType

XlTextParsingType

XlTextQualifier

XlTextVisualLayoutType

XlThemeColor

XlThemeFont

XlThreadMode

XlTickLabelOrientation

XlTickLabelPosition

XlTickMark

XlTimePeriods

XlTimeUnit

XlTimelineLevel

XlToolbarProtection

XlTopBottom

XlTotalsCalculation

XlTrendlineType

XlUnderlineStyle

XlUpdateLinks

XlVAlign

XlWBATemplate

XlWebFormatting

XlWebSelectionType

XlWindowState

XlWindowType

XlWindowView

XlXLMMacroType

XlXmlExportResult

XlXmlImportResult

XlXmlLoadOption

XlYesNoGuess


Member Function Documentation

IDispatch* Add (QVariant Template) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QVariant)), object, SLOT(Add(QVariant)));

Or call the function directly:

	QVariantList params = ...
	QAxObject * result = object->querySubObject("Add(QVariant)", params);

bool CanCheckOut (QString Filename) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString)), object, SLOT(CanCheckOut(QString)));

Or call the function directly:

	QVariantList params = ...
	bool result = object->dynamicCall("CanCheckOut(QString)", params).toBool();

void CheckOut (QString Filename) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString)), object, SLOT(CheckOut(QString)));

Or call the function directly:

	QVariantList params = ...
	object->dynamicCall("CheckOut(QString)", params);

void Close () [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal()), object, SLOT(Close()));

Or call the function directly:

	object->dynamicCall("Close()");

IDispatch* Item (QVariant Index) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QVariant)), object, SLOT(Item(QVariant)));

Or call the function directly:

	QVariantList params = ...
	QAxObject * result = object->querySubObject("Item(QVariant)", params);

IDispatch* Open (QString Filename, QVariant UpdateLinks, QVariant ReadOnly, QVariant Format, QVariant Password, QVariant WriteResPassword, QVariant IgnoreReadOnlyRecommended, QVariant Origin, QVariant Delimiter, QVariant Editable, QVariant Notify, QVariant Converter, QVariant AddToMru, QVariant Local, QVariant CorruptLoad) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)), object, SLOT(Open(QString, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)));

Or call the function directly:

	QVariantList params = ...
	QAxObject * result = object->querySubObject("Open(QString, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)", params);

IDispatch* OpenDatabase (QString Filename, QVariant CommandText, QVariant CommandType, QVariant BackgroundQuery, QVariant ImportDataAs) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString, QVariant, QVariant, QVariant, QVariant)), object, SLOT(OpenDatabase(QString, QVariant, QVariant, QVariant, QVariant)));

Or call the function directly:

	QVariantList params = ...
	QAxObject * result = object->querySubObject("OpenDatabase(QString, QVariant, QVariant, QVariant, QVariant)", params);

void OpenText (QString Filename, QVariant Origin, QVariant StartRow, QVariant DataType, XlTextQualifier TextQualifier, QVariant ConsecutiveDelimiter, QVariant Tab, QVariant Semicolon, QVariant Comma, QVariant Space, QVariant Other, QVariant OtherChar, QVariant FieldInfo, QVariant TextVisualLayout, QVariant DecimalSeparator, QVariant ThousandsSeparator, QVariant TrailingMinusNumbers, QVariant Local) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString, QVariant, QVariant, QVariant, XlTextQualifier, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)), object, SLOT(OpenText(QString, QVariant, QVariant, QVariant, XlTextQualifier, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)));

Or call the function directly:

	QVariantList params = ...
	object->dynamicCall("OpenText(QString, QVariant, QVariant, QVariant, XlTextQualifier, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)", params);

IDispatch* OpenXML (QString Filename, QVariant Stylesheets, QVariant LoadOption) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString, QVariant, QVariant)), object, SLOT(OpenXML(QString, QVariant, QVariant)));

Or call the function directly:

	QVariantList params = ...
	QAxObject * result = object->querySubObject("OpenXML(QString, QVariant, QVariant)", params);

IDispatch* _Default (QVariant Index) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QVariant)), object, SLOT(_Default(QVariant)));

Or call the function directly:

	QVariantList params = ...
	QAxObject * result = object->querySubObject("_Default(QVariant)", params);

IDispatch* _Open (QString Filename, QVariant UpdateLinks, QVariant ReadOnly, QVariant Format, QVariant Password, QVariant WriteResPassword, QVariant IgnoreReadOnlyRecommended, QVariant Origin, QVariant Delimiter, QVariant Editable, QVariant Notify, QVariant Converter, QVariant AddToMru) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)), object, SLOT(_Open(QString, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)));

Or call the function directly:

	QVariantList params = ...
	QAxObject * result = object->querySubObject("_Open(QString, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)", params);

void _OpenText (QString Filename, QVariant Origin, QVariant StartRow, QVariant DataType, XlTextQualifier TextQualifier, QVariant ConsecutiveDelimiter, QVariant Tab, QVariant Semicolon, QVariant Comma, QVariant Space, QVariant Other, QVariant OtherChar, QVariant FieldInfo, QVariant TextVisualLayout, QVariant DecimalSeparator, QVariant ThousandsSeparator) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString, QVariant, QVariant, QVariant, XlTextQualifier, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)), object, SLOT(_OpenText(QString, QVariant, QVariant, QVariant, XlTextQualifier, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)));

Or call the function directly:

	QVariantList params = ...
	object->dynamicCall("_OpenText(QString, QVariant, QVariant, QVariant, XlTextQualifier, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)", params);

IDispatch* _OpenXML (QString Filename, QVariant Stylesheets) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString, QVariant)), object, SLOT(_OpenXML(QString, QVariant)));

Or call the function directly:

	QVariantList params = ...
	QAxObject * result = object->querySubObject("_OpenXML(QString, QVariant)", params);

void __OpenText (QString Filename, QVariant Origin, QVariant StartRow, QVariant DataType, XlTextQualifier TextQualifier, QVariant ConsecutiveDelimiter, QVariant Tab, QVariant Semicolon, QVariant Comma, QVariant Space, QVariant Other, QVariant OtherChar, QVariant FieldInfo, QVariant TextVisualLayout) [slot]

Connect a signal to this slot:

	QObject::connect(sender, SIGNAL(someSignal(QString, QVariant, QVariant, QVariant, XlTextQualifier, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)), object, SLOT(__OpenText(QString, QVariant, QVariant, QVariant, XlTextQualifier, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)));

Or call the function directly:

	QVariantList params = ...
	object->dynamicCall("__OpenText(QString, QVariant, QVariant, QVariant, XlTextQualifier, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant, QVariant)", params);

void exception (int code, QString source, QString disc, QString help) [signal]

For more information, see help context 104001 in C:\Program Files\Microsoft Office 15\Root\Office15\VBAXL10.CHM.

Connect a slot to this signal:

	QObject::connect(object, SIGNAL(exception(int, QString, QString, QString)), receiver, SLOT(someSlot(int, QString, QString, QString)));

void propertyChanged (QString name) [signal]

For more information, see help context 104001 in C:\Program Files\Microsoft Office 15\Root\Office15\VBAXL10.CHM.

Connect a slot to this signal:

	QObject::connect(object, SIGNAL(propertyChanged(QString)), receiver, SLOT(someSlot(QString)));

void signal (QString name, int argc, void* argv) [signal]

For more information, see help context 104001 in C:\Program Files\Microsoft Office 15\Root\Office15\VBAXL10.CHM.

Connect a slot to this signal:

	QObject::connect(object, SIGNAL(signal(QString, int, void*)), receiver, SLOT(someSlot(QString, int, void*)));

Property Documentation

QString objectName

Read this property's value using QObject::property:

	QString val = object->property("objectName").toString();
Set this property' value using QObject::setProperty:
	QString newValue = ...
	object->setProperty("objectName", newValue);
Or using the setObjectName slot.

IDispatch* Application

Read this property's value using QObject::property:

	IDispatch* val = object->property("Application").toIDispatch*();

int Count

Read this property's value using QObject::property:

	int val = object->property("Count").toInt();

XlCreator Creator

Read this property's value using QObject::property:

	int val = object->property("Creator").toInt();

See also XlCreator.

IDispatch* Parent

Read this property's value using QObject::property:

	IDispatch* val = object->property("Parent").toIDispatch*();

IUnknown* _NewEnum

Read this property's value using QObject::property:

	IUnknown* val = object->property("_NewEnum").toIUnknown*();

QString control

Read this property's value using QObject::property:

	QString val = object->property("control").toString();
Set this property' value using QObject::setProperty:
	QString newValue = ...
	object->setProperty("control", newValue);
Or using the setControl slot.