Hi guys,
I need a way to convert my excel files to pdf that can have any no of rows. but the no of rows per each page is a constant and each page should have an image in the footer. an example would be if i have 150 rows and the constants per page is 100 then i need to get a pdf file with two pages and each of these pages should have a footer image?
any idea how I can go about the same. I am thinking about writing a small program for the same. But I need suggestion regarding which tool to use for the conversion depending on the ease of use. I am also thinking about maintaining a constants file that feeds in the required details. like no of rows, footer image location, file location etc.
Thanks. waiting for a reply.
Edit:
Well guys I have 1000 of such files and I cant possibly open each one of these files and add footer etc and saving it as pdf. I need to automate this.