Documentazione HotXLS
Home Contenuti Panoramica

AutoFilterColumns proprietà

Restituisce the classic XLS AutoFilter field collection for the worksheet. Read-only

Sintassi

proprietà AutoFilterColumns: TXLSAutofilter;

Osservazioni

La raccolta usa indici di campo in base 1 corrispondenti alle colonne AutoFilter visibili. Count returns the number of filtered columns in the current range. Items[Field] e Find(Field) return a TXLSAutofilterItem for that field o nil when the field index is outside the current range
Each item exposes Active, Operator, Criteria1, e Criteria2. Criteria objects expose the stored BIFF8 DOPER DataType, grbitSgn, e Value

Esempio

Sheet.ApplyAutoFilter('A1:C5', 2, '>=100');
FilterItem := Sheet.AutoFilterColumns.Find(2);
if Assigned(FilterItem) and FilterItem.Active then
  CriteriaValue := FilterItem.Criteria1.Value;

Vedere Also

TXLSWorksheet.ApplyAutoFiltermetodo
TXLSWorksheet.SetAutoFiltermetodo
TXLSWorksheet.AutoFilterRange proprietà
IXLSRange.Autofiltermetodo
TXLSWorksheet class