locked
Setting data source programmatically for Pivot table RRS feed

  • Question

  • Hi,
       Does anyone know if a worksheet has a Pivot table, how can I set it data source programmatically via VSTO?  Is there any sample code?


    Watcher
    Wednesday, November 16, 2005 9:54 AM

Answers

  • VSTO doesn't have databindable pivot table control. So you will need to use the Excel object model to manipulate the pivot table.

    Paul Stubbs
    Program Manager
    Wednesday, November 23, 2005 6:30 PM

All replies

  • Hi,
       Can anyone help?  What I mean is that if I have a Pivot table, how do I, using VSTO, bind the data to the pivot table?

    Watcher

    Thursday, November 17, 2005 8:42 AM
  • VSTO doesn't have databindable pivot table control. So you will need to use the Excel object model to manipulate the pivot table.

    Paul Stubbs
    Program Manager
    Wednesday, November 23, 2005 6:30 PM