PrintOptions

23 Sep 20251 minute to read

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).