/// <summary>
/// Adds a caption (label) filter for a pivot tabel field
/// </summary>
/// <param name="type"></param>
/// <param name="value1"></param>
/// <param name="value2"></param>
/// <returns></returns>
public ExcelPivotTableFilter AddCaptionFilter(ePivotTableCaptionFilterType type, string value1, string value2 = null)
{
ExcelPivotTableFilter filter = CreateFilter();
filter.Type = (ePivotTableFilterType)type;
filter.StringValue1 = value1;
filter.Value1 = value1;
filter.Value2 = value2;
if (!string.IsNullOrEmpty(value2))
{
filter.StringValue2 = value2;
}
switch (type)
{
case ePivotTableCaptionFilterType.CaptionEqual:
filter.CreateValueFilter();
break;
default:
filter.CreateCaptionCustomFilter(type);
break;
}
filter.Filter.Save();
_filters.Add(filter);
return(filter);
}
public ExcelPivotTableFilter AddValueFilter(ePivotTableValueFilterType type, int dataFieldIndex, object value1, object value2 = null)
{
if (dataFieldIndex < 0 || dataFieldIndex >= _table.DataFields.Count)
{
throw new ArgumentException("dataFieldIndex must point to an item in the pivot tables DataFields collection", "dataFieldIndex");
}
if (value2 == null &&
(type == ePivotTableValueFilterType.ValueBetween ||
type == ePivotTableValueFilterType.ValueNotBetween))
{
throw new ArgumentNullException("value2", "Between filters require two values");
}
ExcelPivotTableFilter filter = CreateFilter();
filter.Type = (ePivotTableFilterType)type;
filter.Value1 = value1;
filter.Value2 = value2;
filter.MeasureFldIndex = dataFieldIndex;
filter.CreateValueCustomFilter(type);
filter.Filter.Save();
_filters.Add(filter);
return(filter);
}
public ExcelPivotTableFilter AddDatePeriodFilter(ePivotTableDatePeriodFilterType type)
{
ExcelPivotTableFilter filter = CreateFilter();
filter.Type = (ePivotTableFilterType)type;
filter.CreateDateDynamicFilter(type);
filter.Filter.Save();
_filters.Add(filter);
return(filter);
}
public ExcelPivotTableFilter AddDateValueFilter(ePivotTableDateValueFilterType type, DateTime value1, DateTime?value2 = null)
{
if (value2.HasValue == false &&
(type == ePivotTableDateValueFilterType.DateBetween ||
type == ePivotTableDateValueFilterType.DateNotBetween))
{
throw new ArgumentNullException("value2", "Between filters require two values");
}
ExcelPivotTableFilter filter = CreateFilter();
filter.Type = (ePivotTableFilterType)type;
filter.Value1 = value1;
filter.Value2 = value2;
filter.CreateDateCustomFilter(type);
filter.Filter.Save();
_filters.Add(filter);
return(filter);
}
/// <summary>
/// Adds a top 10 filter to the field
/// </summary>
/// <param name="type">The top-10 filter type</param>
/// <param name="dataFieldIndex">The index to the data field within the pivot tables DataField collection</param>
/// <param name="value">The top or bottom value to relate to </param>
/// <param name="isTop">Top or bottom. true is Top, false is Bottom</param>
/// <returns></returns>
public ExcelPivotTableFilter AddTop10Filter(ePivotTableTop10FilterType type, int dataFieldIndex, double value, bool isTop = true)
{
if (dataFieldIndex < 0 || dataFieldIndex >= _table.DataFields.Count)
{
throw new ArgumentException("dataFieldIndex must point to an item in the pivot tables DataFields collection", "dataFieldIndex");
}
ExcelPivotTableFilter filter = CreateFilter();
filter.Type = (ePivotTableFilterType)type;
filter.Value1 = value;
filter.MeasureFldIndex = dataFieldIndex;
filter.CreateTop10Filter(type, isTop, value);
filter.Filter.Save();
_filters.Add(filter);
return(filter);
}