PrintOptions API in JavaScript (ES5) Spreadsheet API control

Represents the options available for printing functionality in the spreadsheet. These options allow you to customize the print settings, such as selecting specific sheets or including headers and gridlines.

Properties

allowGridLines

boolean

Specifies whether to include gridlines in the printed output. Gridlines are the light gray lines that separate cells in the spreadsheet.

• true: Prints the sheet with gridlines.
• false: Prints the sheet without gridlines.

allowRowColumnHeader

boolean

Specifies whether to include row and column headers (like A, B, C for columns and 1, 2, 3 for rows) in the printed output.

• true: Includes row and column headers in the printout.
• false: Excludes row and column headers from the printout.

type

PrintType

Determines what part of the spreadsheet should be printed. Values:

• “Worksheet”: Prints only the active worksheet.
• “Workbook”: Prints the entire workbook (all sheets).