Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
visual c# excel 2007 pivot filter
Hi,
I'm trying to add pivot filter with multiple values checked using visual c# 2008, we tried using the xldatebetween syntax property of the pivot function, but keep getting an error on the object data property. Can someone please guide me to the right syntax below is the string from the code tablePage1.PivotFilters.Add(Excel.XlPivotFilterTyp e.xlDateBetween,tablePivot.PivotFields("Posted Date"),"12/7/2009", missing, missing, missing, missing, missing); |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
visual c# excel 2007 pivot filter
On Wednesday, 16 December 2009 03:58:15 UTC+5:30, @discussions.microsoft.com Scott wrote:
Hi, I'm trying to add pivot filter with multiple values checked using visual c# 2008, we tried using the xldatebetween syntax property of the pivot function, but keep getting an error on the object data property. Can someone please guide me to the right syntax below is the string from the code oPivotField.PivotFilters.Add(XlPivotFilterType.xlT opCount, oPivotTable.PivotFields("UserName"), 5, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); On Wednesday, 16 December 2009 03:58:15 UTC+5:30, @discussions.microsoft.com Scott wrote: Hi, I'm trying to add pivot filter with multiple values checked using visual c# 2008, we tried using the xldatebetween syntax property of the pivot function, but keep getting an error on the object data property. Can someone please guide me to the right syntax below is the string from the code oPivotField.PivotFilters.Add(XlPivotFilterType.xlT opCount, oPivotTable.PivotFields("UserName"), 5, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Label Filter in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot Table Filter/Check Box | Excel Programming | |||
Excel 2007 Pivot Table Filter (multi value) | Excel Discussion (Misc queries) | |||
add filter to pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
How do I programatically pass in a filter to an excel 2007 pivot t | Excel Programming |