ExcelScript.PrintComments enum

Package:

ExcelScript

Remarks

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

endSheet	Comments will be printed as end notes at the end of the worksheet.
inPlace	Comments will be printed where they were inserted in the worksheet.
noComments	Comments will not be printed.