ExcelScript.PrintComments enum
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. |