ExcelScript.PrintComments enum

Remarks

Used by

• ExcelScript.PageLayout: getPrintComments, setPrintComments

Examples

/**
 * This script makes the comments print at the end of the worksheet
 * when the workbook is printed.
 */
function main(workbook: ExcelScript.Workbook) {
 // Access every worksheet in the workbook.
 workbook.getWorksheets().forEach(worksheet => {
 // Get the page layout for each sheet.
 const layout = worksheet.getPageLayout();

 // Change the comment printing settings to print them at the end of the sheet.
 layout.setPrintComments(ExcelScript.PrintComments.endSheet);
 });
}

Fields