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

Free Support Forum - aspose.com

Freezing headers in Pivot Table

Hi Aspose Team,

I have pivot table with lot of data , Hence I want to Freeze Pivot Table Header on Scroll of Sheet through Coding.

Hi,


I think you may use Worksheet.FreezePanes() method accordingly.
See the demo and docs for your reference:
http://www.aspose.com/demos/.net-components/aspose.cells/csharp/quick-start/worksheets/freeze-panes.aspx
http://docs.aspose.com/display/cellsnet/Freeze+Panes

Thank you.