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

Free Support Forum - aspose.com

Eliminate pagebreak between two sheets in PDF

Hello,

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?

Regards
Ringo

Hi,


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:
http://docs.aspose.com/display/cellsnet/Setting+Page+Options
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.