wxAutoExcel
2.0.0
|
Represents Microsoft Excel AutoFilter object. More...
Public Member Functions | |
void | ApplyFilter () |
Applies the specified Autofilter object. More... | |
void | ShowAllData () |
Displays all the data returned by the AutoFilter object. More... | |
bool | GetFilterMode () |
Returns True if the worksheet is in the AutoFilter filter mode. More... | |
wxExcelFilters | GetFilters () |
Returns a Filters collection that represents all the filters in an autofiltered range. More... | |
wxExcelRange | GetRange () |
Returns a Range Represents the range to which the specified AutoFilter applies. More... | |
wxExcelSort | GetSort () |
Gets the sort column or columns, and sort order for the AutoFilter collection. More... | |
virtual wxString | GetAutoExcelObjectName_ () const |
Returns "AutoFilter". More... | |
Public Member Functions inherited from wxAutoExcel::wxExcelObject | |
bool | IsOk_ () const |
Returns true if the object has a valid dispatch. More... | |
wxString | GetAutomationObjectName_ (bool stripUnderscores=false) const |
Returns object name as provided by IDispatch->GetTypeInfo()->GetDocumentation(MEMBERID_NIL, &name, NULL, NULL, NULL). More... | |
wxSharedPtr< wxAutomationObject > | GetAutomationObject_ () |
Returns the underlying wxAutomationObject. More... | |
operator bool () const | |
Returns true if the object has a valid dispatch and its last automation call (if any), i.e. More... | |
WXLCID | GetAutomationLCID_ () const |
Returns the locale identifier used in automation calls. More... | |
bool | SetAutomationLCID_ (WXLCID lcid) |
Sets the locale identifier to be used in automation calls. More... | |
bool | GetPropertyAndMethodNames_ (wxArrayString &propertyNames, wxArrayString &methodNames, bool includeHidden=false) |
Returns lists of property and method names the automation interface exposes. More... | |
bool | GetUnimplementedObject_ (const wxString &name, wxAutomationObject &object) |
Helper function for receiving an automation object not implemented in wxAutoExcel, see FAQ on how to use. More... | |
Additional Inherited Members | |
Public Types inherited from wxAutoExcel::wxExcelObject | |
enum | ErrorFlags { Err_DoNothing = 0 , Err_LogOnInvalidDispatch = 1 , Err_AssertOnInvalidDispatch = 1 << 1 , Err_ThrowOnInvalidDispatch = 1 << 2 , Err_LogOnInvalidArgument = 1 << 3 , Err_AssertOnInvalidArgument = 1 << 4 , Err_ThrowOnInvalidArgument = 1 << 5 , Err_LogOnFailedInvoke = 1 << 6 , Err_AssertOnFailedInvoke = 1 << 7 , Err_ThrowOnFailedInvoke = 1 << 8 , Err_LogOnInvalidReturnType = 1 << 9 , Err_AssertOnInvalidReturnType = 1 << 10 , Err_ThrowOnInvalidReturnType = 1 << 11 , Err_LogOnOtherError = 1 << 12 , Err_AssertOnOtherError = 1 << 13 , Err_ThrowOnOtherError = 1 << 14 } |
Flags affecting the behaviour of wxExcelObject and its descendants when an error occurs during accessing an Excel object property or calling its method. More... | |
Static Public Member Functions inherited from wxAutoExcel::wxExcelObject | |
static unsigned | GetErrorMode_ () |
Sets the error mode to the combination of wxExcelObject::ErrorFlags. More... | |
static void | SetErrorMode_ (unsigned mode) |
Sets the error mode as the combination of wxExcelObject::ErrorFlags. More... | |
static bool | GetUnimplementedCollectionItem_ (wxAutomationObject &collection, const long index, wxAutomationObject &item, bool asProperty) |
Helper function for obtaining an item from MS Excel collection not implemented in wxAutoExcel, see FAQ on how to use. More... | |
Represents Microsoft Excel AutoFilter object.
void wxAutoExcel::wxExcelAutoFilter::ApplyFilter | ( | ) |
Applies the specified Autofilter object.
void wxAutoExcel::wxExcelAutoFilter::ShowAllData | ( | ) |
Displays all the data returned by the AutoFilter object.
bool wxAutoExcel::wxExcelAutoFilter::GetFilterMode | ( | ) |
Returns True if the worksheet is in the AutoFilter filter mode.
Since Excel 2007.
wxExcelFilters wxAutoExcel::wxExcelAutoFilter::GetFilters | ( | ) |
Returns a Filters collection that represents all the filters in an autofiltered range.
wxExcelRange wxAutoExcel::wxExcelAutoFilter::GetRange | ( | ) |
Returns a Range Represents the range to which the specified AutoFilter applies.
wxExcelSort wxAutoExcel::wxExcelAutoFilter::GetSort | ( | ) |
Gets the sort column or columns, and sort order for the AutoFilter collection.
Since Excel 2007.
|
inlinevirtual |
Returns "AutoFilter".
Reimplemented from wxAutoExcel::wxExcelObject.