Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I m trying to access the page fields of an Excel 2007 pivot table with a VSTO
addin written in c# I m having the Exception ("Exception from HRESULT: 0x800A03EC") when I try to display the CurrentPageName, here is the snippet code I m using: <code try { Excel.PivotFields pFields = (Excel.PivotFields)cell.PivotTable.get_PageFields( System.Reflection.Missing.Value); int count = pFields.Count; for (int i = 1; i <= count; i++) { Excel.PivotField pf = (Excel.PivotField)cell.PivotTable.get_PageFields(( object)i); String s = pf.CurrentPageName; MessageBox.Show(s); } } catch(Exception e) { } </code I m having an issue with Excel 2007, however evrything is ok when I run this for Excel 2003. did the api of the pivot table changed from 2003 to 2007 ? did someone succeeded in getting the page fields froma pivot table in excel 2007 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 / 2003 Pivottable Macro | Excel Discussion (Misc queries) | |||
error 1004 when setting pivottable.pagefields | Excel Discussion (Misc queries) | |||
problem with pivotTable in Excel | Excel Discussion (Misc queries) | |||
Excel 2007/2003 Pivottable compatibility | Excel Discussion (Misc queries) | |||
Pivottable feature(?) in Excel 2003 SP-1 | Excel Discussion (Misc queries) |