Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Thomas
60
Export to a file that contains a pivot table
posted

Hello,

I need to export data from a grid to excel. I did this several times, but this time the template file has a pivot table in the second worksheet. I export data to the first worksheet, and the pivot table should use this data in the second worksheet.

The problem is that the pivot table works fine in the template file, but it seems to have disappeared after the export. The second worksheet is still present and has all the formatting, titles, etc., except the pivot table.

The data export in the first worksheet works fine too.

I use Workbook.Load(templatePath) and Workbook.Save(destinationPath) in Infragistics 2008.3. I can send the files before and after export by PM.

I just can't see why the pivot table disappears during the export.

Thanks,

Thomas.

  • 65
    posted

    Hi,

    I'm bumping this as I have the exact same problem and would really appreciate an explanation.

    All I've been able to verify is that the pivot is lost in the process of loading and saving the workbook, regardless of whether you export data to it.

    I'm using 2009.1

    Regards

    David