Free Support Forum -

Reapeating column headers when printing to excel


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



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)


//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.