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

Free Support Forum - aspose.com

How to deal with wide excel?

If an excel is wide, it will be unreadable when converted to pdf.





While if I call setOnePagePerSheet(true), the whole sheet will be in on pdf page. If the sheet is long, the pdf page will be very large.





Is it possible to keep colums in pdf page but still cut into multiple pages according to rows?

Hi,


Please see the document for your reference:
http://www.aspose.com/docs/display/cellsjava/Fit+All+Worksheet+Columns+on+Single+PDF+Page

You may try to use PdfSaveOptions.setAllColumnsInOnePagePerSheet that ensures all columns of a worksheet are rendered to a single PDF page, although rows may expand to several pages depending upon the data in worksheet.

Thank you.

Thanks a lot.
That exactly what I want.

Hi,


Good to know that it sorts out your issue now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.