Hi;
We examined Setting Headers and Footers|Documentation (aspose.com) and Setting Headers and Footers|Documentation (aspose.com) this.
We could set Header and Footer on excel file. But we have problem about font color, size, name of header and footer text.
Here is ours code:
Workbook wb = new Workbook(stream);
foreach(Worksheet sheet in wb.Worksheets){
PageSetup pageSetup = sheet.PageSetup;
pageSetup.SetHeader(0,"Left Header Sample &\"Times New Roman\"&12");
pageSetup.SetHeader(1,"Middle Header Sample &\"Times New Roman\"&14&KFF0000");
pageSetup.SetHeader(2,"Right Header Sample &\"Times New Roman\"&12");
pageSetup.SetFooter(1,"Middle Footer Sample &\"Times New Roman\"&14&KFF0000");
}
In my code, is similar to samples in yours documentaries which I share in begining of this post. But, texts writes in header and footer as “Calibri”, font size 12, font color black and not bold.
Where I am wrong? How can I do that?
Thanks a lot.