Skip to main content

SetLeftHeader

Sets the left part of the header used when the worksheet is printed.

Syntax​

expression.SetLeftHeader(sText);

expression - A variable that represents an ApiPageSetup class.

Parameters​

NameRequired/OptionalData typeDefaultDescription
sTextRequiredstringThe left header text (may contain formatting codes such as &P, &D).

Returns​

boolean

Example​

Add left text to the page header for printing in a spreadsheet.

// How do I put text on the left side of the header in a spreadsheet?

// Show a left header when printing a spreadsheet.

let worksheet = Api.GetActiveSheet();
let pageSetup = worksheet.GetPageSetup();
pageSetup.SetLeftHeader("Confidential");