Add page number on the excel file which shows when i print the excel file

Jan 28, 2013 at 3:38 AM


i wanted to know how can you add dynamically a page number on the outputed excel file.

Im not refering to the paging of the gridview, just i want to display a page number in excel file so that when i print the file i can see something like this: "Page 1 of 2".

any help?