Using XlsIO I have created the excel sheet as required.
I require the following of the footer:
1. Width of footer should be the width of the page.
2. The footer should have a border around it.
3. The footer should optionally have a background color.
4. There should be an image in the center of the footer.
I can create the footer and add an image to the center of the footer, but not the other requirement.
IPageSetup pageSetup = (IPageSetup)worksheet.PageSetup;
pageSetup.CenterFooterImage = Image.FromFile(server.MapPath("~\\Content\\Images\\filename.png"));
pageSetup.CenterFooter = "&G";