Thank you for the reply.
I tried the same code with the latest version you provided, and I'm still having the same issue.
Here are the sample files: the excel sheet, the pdf file I got using aspose and the pdf file obtained saving the file as pdf using excel.
The print preview looks exactly like the pdf file generated by excel. (ExcelOutput.pdf).
The file generated by Aspose doesn't show the page numbers. (AsposeOutput.pdf)
This pdf was generated using the code mentioned above: