Free Support Forum -

How to freeze excel header using ASPOSE


We just purchased ASPOSE.cell (aspose.cell_2.5.4.14) and I'd like to know if it's possible to do following task from a java servlet by using ASPOSE:

We would like generate an Excel file which mimic what
the generic Excel rendering does i.e. the Report Header is showing only once at the top of the Excel file in the normal page view of excel but when you go to print preview it will display the header for each page and print it correctly.

Any help is greatly appreciated.



Please create a sample desired output xlsx file and attach here. You can create one manually using Ms-Excel. We will investigate how to create your desired file programmatically using Aspose.Cells for Java Api(s).

Also, for setting Headers and Footers, you should refer to the following document:
Setting Headers and Footers

If you want to use general freezing, then please refer to this document:
Freeze Panes

Also, we recommend to upgrade your application and use the latest version: Aspose.Cells for Java v7.0.1