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

Free Support Forum - aspose.com

Eliminate pagebreak between two sheets in PDF


I have an Excel workbook with some sheets and I want to convert it to pdf. Every sheet forces a pagebreak in the PDF file. But I want that after only one sheet no pagebreak is insert.

Is it possible and how can I do it?



Well, Aspose.Cells rendering engine renders PDF document based on the print preview of MS Excel worksheets by default. It renders all the PDF document’s pages similar to Print preview of MS Excel and when rendering next worksheet if will start a new page in the PDF document.

Well, for your requirement, you have to paste the other sheets’s contents (data/objects etc.) in a single worksheet, also you may try to set fit to pages tall/wide options accordingly of the PageSetup, see the document for reference:
Moreover, you may try some PageSetup's print options (see the document: http://docs.aspose.com/display/cellsnet/Setting+Print+Options). Everything which is suggested above should be done before saving to PDF document.

Thank you.