Interface "Edit in Excel Field Filter v2"
Namespace: System.Integration.Excel
This codeunit provides an interface to create a filter for a specific field for Edit in Excel.
Methods
AddFilterValueV2
Add a filter value
procedure AddFilterValueV2(EditInExcelFilterType: Enum "Edit in Excel Filter Type", FilterValue: Text): Interface "Edit in Excel Field Filter v2"Parameters
| Name | Type | Description |
|---|---|---|
| EditInExcelFilterType | Enum System.Integration.Excel."Edit in Excel Filter Type" |
The filter type, such as Equal, Greater than. |
| FilterValue | Text |
The value which the field should be Equal to, Greater than etc. |
Returns
| Type | Description |
|---|---|
| Interface System.Integration.Excel."Edit in Excel Field Filter v2" |
Get
Get a specific filter
procedure Get(Index: Integer, var EditinExcelFilterType: Enum "Edit in Excel Filter Type", var FilterValue: Text)Parameters
| Name | Type | Description |
|---|---|---|
| Index | Integer |
The index of the filter. |
| EditinExcelFilterType | Enum System.Integration.Excel."Edit in Excel Filter Type" |
The index of the filter. |
| FilterValue | Text |
The value which the field should be Equal to, Greater than etc. |
GetCollectionType
Get the filter collection type
procedure GetCollectionType(): Enum "Edit in Excel Filter Collection Type"Returns
| Type | Description |
|---|---|
| Enum System.Integration.Excel."Edit in Excel Filter Collection Type" |
The collection type of the filter |
Remove
Remove a specific filter
procedure Remove(Index: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| Index | Integer |
The index of the filter. |
Count
Counts the number of filters
procedure Count(): IntegerReturns
| Type | Description |
|---|---|
| Integer |
The number of filters |