wxAutoExcel 2.5.1
Loading...
Searching...
No Matches
wxAutoExcel::wxExcelSortFields Class Reference

Represents Microsoft Excel SortFields collection. More...

#include <wxAutoExcelSortFields.h>

Inheritance diagram for wxAutoExcel::wxExcelSortFields:
wxAutoExcel::wxExcelObject

Public Types

typedef wxExcelCollectionIterator< wxExcelSortFields, wxExcelSortField > iterator
 The iterator over the items, see wxExcelCollectionIterator.
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...

Public Member Functions

wxExcelSortField Add (wxExcelRange range, XlSortOn sortOn, XlSortOrder *order=NULL, const wxString &customOrder=wxEmptyString, XlSortDataOption *dataOption=NULL)
 Creates a new sort field and returns a SortFields object.
void Clear ()
 Clears all the SortFields objects.
long GetCount ()
 Returns the number of objects in the collection.
wxExcelSortField GetItem (long index)
 Returns a SortField Represents a collection of items that can be sorted in a workbook.
iterator begin ()
 Returns the iterator referring to the first item, or past the last item, which allows iterating over the items with a range-based for loop, see wxExcelCollectionIterator.
virtual wxString GetAutoExcelObjectName_ () const
 Returns "SortFields".
Public Member Functions inherited from wxAutoExcel::wxExcelObject
bool IsOk_ () const
 Returns true if the object has a valid dispatch.
wxString GetAutomationObjectName_ (bool stripUnderscores=false) const
 Returns object name as provided by IDispatch->GetTypeInfo()->GetDocumentation(MEMBERID_NIL, &name, NULL, NULL, NULL).
wxSharedPtr< wxAutomationObject > GetAutomationObject_ ()
 Returns the underlying wxAutomationObject.
 operator bool () const
 Returns true if the object has a valid dispatch and its last automation call (if any), i.e.
bool IsLastResultNull_ () const
 Returns true if MS Excel returned Null (or Empty) for the last property or method, e.g.
WXLCID GetAutomationLCID_ () const
 Returns the locale identifier used in automation calls.
bool SetAutomationLCID_ (WXLCID lcid)
 Sets the locale identifier to be used in automation calls.
bool GetPropertyAndMethodNames_ (wxArrayString &propertyNames, wxArrayString &methodNames, bool includeHidden=false)
 Returns lists of property and method names the automation interface exposes.
bool GetUnimplementedObject_ (const wxString &name, wxAutomationObject &object)
 Helper function for receiving an automation object not implemented in wxAutoExcel, see FAQ on how to use.

Additional Inherited Members

Static Public Member Functions inherited from wxAutoExcel::wxExcelObject
static unsigned GetErrorMode_ ()
 Sets the error mode to the combination of wxExcelObject::ErrorFlags.
static void SetErrorMode_ (unsigned mode)
 Sets the error mode as the combination of wxExcelObject::ErrorFlags.
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.

Detailed Description

Represents Microsoft Excel SortFields collection.

Member Typedef Documentation

◆ iterator

Member Function Documentation

◆ Add()

wxExcelSortField wxAutoExcel::wxExcelSortFields::Add ( wxExcelRange range,
XlSortOn sortOn,
XlSortOrder * order = NULL,
const wxString & customOrder = wxEmptyString,
XlSortDataOption * dataOption = NULL )

Creates a new sort field and returns a SortFields object.

MSDN documentation for SortFields.Add.

◆ Clear()

void wxAutoExcel::wxExcelSortFields::Clear ( )

Clears all the SortFields objects.

MSDN documentation for SortFields.Clear.

◆ GetCount()

long wxAutoExcel::wxExcelSortFields::GetCount ( )

Returns the number of objects in the collection.

Since Excel 2007.

MSDN documentation for SortFields.Count.

◆ GetItem()

wxExcelSortField wxAutoExcel::wxExcelSortFields::GetItem ( long index)

Returns a SortField Represents a collection of items that can be sorted in a workbook.

Since Excel 2007.

MSDN documentation for SortFields.Item.

◆ begin()

iterator wxAutoExcel::wxExcelSortFields::begin ( )
inline

Returns the iterator referring to the first item, or past the last item, which allows iterating over the items with a range-based for loop, see wxExcelCollectionIterator.

◆ GetAutoExcelObjectName_()

virtual wxString wxAutoExcel::wxExcelSortFields::GetAutoExcelObjectName_ ( ) const
inlinevirtual

Returns "SortFields".

Reimplemented from wxAutoExcel::wxExcelObject.