AutoFilterColumns property - HotXLS Geliştirici Başvurusu

Döndürür the classic XLS AutoFilter field collection for the worksheet. Read-only

Sözdizimi

property AutoFilterColumns: TXLSAutofilter;

Açıklamalar

Koleksiyon, görünür AutoFilter sütunlarıyla eşleşen 1 tabanlı alan dizinlerini kullanır. Count returns the number of filtered columns in the current range. Items[Field] and Find(Field) return a TXLSAutofilterItem for that field or nil when the field index is outside the current range

Each item exposes Active, Operator, Criteria1, and Criteria2. Criteria objects expose the stored BIFF8 DOPER DataType, grbitSgn, and Value

Örnek

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

AutoFilterColumns özellik

Sözdizimi

Açıklamalar

Örnek

See Also