We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How can I create an image of a Pivot Table?

I need to create an image snapshot of a pivot table in an excel spreadsheet. I used the toImage() method of a chart to create an image of a chart, but I don’t see a comparable method on pivot table.

Hi,


Thanks for your posting and considering Aspose.Cells.

You can get the image of entire worksheet or part of worksheet. So, if you want to get the image of your pivot table, you will have to take the image of the part of worksheet where your pivot table lies.

For example, your pivot table lies in a range A1:F20, then you can set the print area to A1:F20 and get the image of entire worksheet.

Please read this article that explains how to get the image of the range of worksheet.


I’m not going to know ahead of time what the cell range is for the pivot table. Is there a way I can determine the cell range using the pivot table name?

Hi,


Thanks for your posting and considering Aspose.Cells.

Yes, you can find the range of your entire pivot table using the PivotTable.getTableRange1() method.