Valid values for the SetHeader and SetFooter Script Commands

Aspose.Cells Product Family
1

Using the pageSetup.SetFooter() function, the parameters are

SetFooter(section, script)

The documentation at http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/setting-headers-and-footers.html gives several examples of scripting commands such as:

&“Arial”
and
&“Arial,Bold”

What is the setting for having underline text in the header and footer? And what is the setting to turn off underline? I want the following text in a footer section:

Note: Closing dates without a scheduled time are estimates based on Purchase Agrm

Thanks,

James

2

Hi,

Please see the following sample code for your need.

//Instantiating a Workbook object
Workbook workbook = new Workbook();
workbook.Worksheets[0].Cells[“A1”].PutValue(“Testing…”);
//Obtaining the reference of the PageSetup of the worksheet
PageSetup pageSetup = workbook.Worksheets[0].PageSetup;
//Setting a string at the left section of the footer
pageSetup.SetFooter(0, “&L&UNote:&U Closing dates without a scheduled time are &Uestimates&U based on Purchase Agrm”);
workbook.Save(“e:\test\output.xls”);

Thank you.