IXlsSort
COM interface ( getting help with interfaces )

 

interface IXlsSort : IDispatch
{
  [id(1)] HRESULT PrimaryKey([in]int columnindex, [in]BOOL bAscending);
  [id(2)] HRESULT SecondaryKey([in]int columnindex, [in]BOOL bAscending);
  [id(3)] HRESULT TertiaryKey([in]int columnindex, [in]BOOL bAscending);
  [id(4)] HRESULT Apply();
}

 

HRESULT PrimaryKey([in]int columnindex, [in]BOOL bAscending);
sets the column that serves as the primary key for sorting.

HRESULT SecondaryKey([in]int columnindex, [in]BOOL bAscending);
sets the column that serves as the secondary key for sorting.

HRESULT TertiaryKey([in]int columnindex, [in]BOOL bAscending);
sets the column that serves as the tertiary key for sorting.

HRESULT Apply();
sorts the data in the range, according to the sorting keys.