How Do I add background color in the Setfooter or Setheader in Aspose.Cells

Aspose.Cells Product Family
,
1

I am Using Aspose.Cells and I don’t know how to set background color with setFooter. The whole footer not the section.

pageSetup.SetFooter(0, “Make every bit count! &” Verdana,Bold"&14");

2

@Niclause,

I am not sure if this is possible (set background color) for a header/footer even in MS Excel. How could you accomplish the task in MS Excel manually? Could you please share a sample Excel file (you may create the file in MS Excel manually) with your desired header (which has a background color) in tact, save the file and post us. We will check on how to do it via Aspose.Cells APIs.

PS. please zip the Excel file prior attaching