Free Support Forum -

One page per worksheet when converting to PDF

We would like to have page per worksheet when we convert an excel document to a pdf. We have enabled the onePagePerSheet option, which works great. Our only concern is that we would like to have smaller data sets (a few rows in excel) appear to have printed on a full sheet of 8.5" by 11" sheet of paper. Is it possible to achieve this with the onePagePerSheet option?


Thanks for your posting and using Aspose.Cells for .NET.

I am afraid, this might not be possible. When Aspose.Cells try to generated one page per sheet, then Pdf page grows according to the data. You might need the same sized physical paper to get the physical input of the page.