PivotTable PageFields c# / api changes from Excel 2003 to Excel 20
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 ? |
PivotTable PageFields c# / api changes from Excel 2003 to Excel20
Excel 2007 PivotTable
List Page Field headers and items selected. VBA macro http://www.mediafire.com/file/dyojfoyiqzo/09_23_09.xlsm |
PivotTable PageFields c# / api changes from Excel 2003 to Exce
"Herbert Seidenberg" wrote: Excel 2007 PivotTable List Page Field headers and items selected. VBA macro http://www.mediafire.com/file/dyojfoyiqzo/09_23_09.xlsm thnx for the answer Herbert but the issue is not with VB nor VBA isssue I m having is with c# and Excel 2007 with VSTO addin Regards, |
PivotTable PageFields c# / api changes from Excel 2003 to Excel 20
Use pf.CurrentPage instead of pf.CurrentPageName. You may also write Convert.toString(pf.CurrentPage).
On Wednesday, September 23, 2009 8:36 AM tuxmobil wrote: 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 ? On Thursday, September 24, 2009 4:27 AM tuxmobil wrote: "Herbert Seidenberg" wrote: thnx for the answer Herbert but the issue is not with VB nor VBA isssue I m having is with c# and Excel 2007 with VSTO addin Regards, On Friday, September 25, 2009 2:49 PM Herbert Seidenberg wrote: Excel 2007 PivotTable List Page Field headers and items selected. VBA macro http://www.mediafire.com/file/dyojfoyiqzo/09_23_09.xlsm |
PivotTable PageFields c# / api changes from Excel 2003 to Excel 20
Use Convert.ToString(pf.CurrentPage) instead of pf.CurrentPageName.
On Wednesday, September 23, 2009 8:36 AM tuxmobil wrote: 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 ? On Thursday, September 24, 2009 4:27 AM tuxmobil wrote: "Herbert Seidenberg" wrote: thnx for the answer Herbert but the issue is not with VB nor VBA isssue I m having is with c# and Excel 2007 with VSTO addin Regards, On Friday, September 25, 2009 2:49 PM Herbert Seidenberg wrote: Excel 2007 PivotTable List Page Field headers and items selected. VBA macro http://www.mediafire.com/file/dyojfoyiqzo/09_23_09.xlsm On Friday, June 22, 2012 9:08 AM Sandeep Jain wrote: Use pf.CurrentPage instead of pf.CurrentPageName. You may also write Convert.toString(pf.CurrentPage). |
All times are GMT +1. The time now is 02:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com