I am programming in vb.net with your product. I am pulling data from a table and creating a spread sheet. I need to customize the page headers, meaning the left, right and center, from the data in other tables. What I need to do is be able to change the font size and style. Here is what I have put together. I created a strHeader_left which is a string. Below is the code for what I was creating for the header. I was trying to create an underline under the lookup command.
Dim PageSetup As Aspose.Cells.PageSetup = workbook.Worksheets("Sheet1").PageSetup
strHeader_Left = Chr(13) & Chr(13) & Chr(13) & Chr(13) & Chr(13) & Chr(13) & Chr(13) & Chr(13)
strHeader_Left = strHeader_Left & "_______" & Lookup("cefacilities", "sysid=1", "principal") & "_________" & Chr(13)
strHeader_Left = strHeader_Left & " Detail(Officer) "
PageSetup.SetHeader(0, "&""Arial""&10" & strHeader_Left)
But for the others I need to create bold and underline and font size. Is this possible to create such a complex? I am using a spreadsheet template, but the problem arises that the page headers needs to be customized from the data in my tables. I hope this is clear.