Skip to main content

SetLeftFooter

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

Syntax​

expression.SetLeftFooter(sText);

expression - A variable that represents an ApiPageSetup class.

Parameters​

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

Returns​

boolean

Example​

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

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

// Show a left footer when printing a spreadsheet.

let worksheet = Api.GetActiveSheet();
let pageSetup = worksheet.GetPageSetup();
pageSetup.SetLeftFooter("&D");