Free Support Forum - aspose.com

Reapeating column headers when printing to excel

Hi,

Is it possible to have the excel column headers repeat on each page if i print the file to PDF?

Cheers,

Harry

Hi Hary,

Thanks for considering Aspose.

Do you mean you want to print title columns (Columns to repeat on each page), I think you may try to add a line in your code before saving the .xml file (Aspose.Pdf Integrated)

E.g.,

//Instantiate the Workbook object
Workbook workbook = new Workbook();
//Do something here to work on your spreadsheet
.
.
workbook.Worksheets[0].PageSetup.PrintTitleColumns = "$A:$B";
//Save the document in Aspose.Pdf.Xml format
workbook.Save("MySpreadsheet.xml", FileFormatType.AsposePdf);

Thank you.