Thank you for your help. I have a thing to ask… when I set the worksheet.PageSetup.FitToPagesTall property to 1 it tries to fit the complete sheet into the same page on the PDF.
I want to know is there any method in Aspose where if the sheet size is large it moves the cells after a particular number of rows to the next pdf page?
Should I try to do something with Printarea property if it overflows move the data to next page in PDF? Could you please help me with this.