ExcelScript.PrintComments enum

Paquete:

ExcelScript

Comentarios

Ejemplos

/**
 * 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);
  });
}

Campos

endSheet	Los comentarios se imprimirán como notas al final, situados al final de la hoja.
inPlace	Los comentarios se imprimirán en el mismo lugar en que se hayan insertado en la hoja.
noComments	No se imprimirán los comentarios.