Hi,
Is it possible to have the excel column headers repeat on each page if i print the file to PDF?
Cheers,
Harry
Hi,
Is it possible to have the excel column headers repeat on each page if i print the file to PDF?
Cheers,
Harry
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.