Create a Footer that spans the width of the page with a border and an image in the center?

Thread ID:	Created:	Updated:	Platform:	Replies:
146696	Aug 14,2019 01:11 PM UTC	Aug 19,2019 12:21 PM UTC	ASP.NET MVC	1

Subscribe to this post

Tags: XlsIO

Neill

Asked On August 14, 2019 01:11 PM UTC

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";

Neill

Reply | Reply with quote

Abirami Varadharajan [Syncfusion]

Replied On August 19, 2019 12:21 PM UTC

Hi Neill,

Please find the details for your queries below.

Queries	Details
Width of footer should be the width of the page	By default, header and footer will use the page width. Microsoft Excel don’t have an option to specify the width of header and footer.
The footer should have a border around it.	Your requirement of adding border or background color to the header/footer is not possible in Microsoft Excel. So, your requirement can’t be achieved. However, you can format the header or footer text. Please refer to the below documentation to know more on working with header and footers. https://help.syncfusion.com/file-formats/xlsio/faq#how-to-set-or-format-a-headerfooter
The footer should optionally have a background color.

Regards,

Abirami

Reply | Reply with quote

CONTACT US

CONTACT US