Thanks for the file.
I am afraid, there is no better way to cope with if you still want all the pages to be same sized yet the footer will be at the bottom. For your information, Aspose.Cells renders Excel file to PDF file format with same display as you see print preview of different sheets in MS Excel manually. Also, if you use Ms Excel to save the file (after fitting the pages tall/wide or using other PageSetup options) to PDF, you may end us the same output PDF file. I am afraid, I could not find any reliable option in MS Excel to accomplish your task (retaining all the pages’ size same). I guess you should use your original code (as per the first post) to render your file as the page sizes’ difference is not much.
In case, you still think this can be done in MS Excel (when taking the print preview of the sheets), kindly do provide your Excel file with all the details, we will check it soon.