ExcelScript.WorksheetPositionType enum

Paquete:

ExcelScript

Posición de una hoja de cálculo relativa a otra hoja de cálculo o a toda la colección de hojas de cálculo.

Comentarios

Ejemplos

/**
 * This script duplicates a worksheet named "Template". 
 * The new worksheet is added after the template.
 */
function main(workbook: ExcelScript.Workbook) {
  // Get the worksheet named "Template".
  let template = workbook.getWorksheet("Template");

  // Copy the worksheet.
  let newSheet = template.copy(
    ExcelScript.WorksheetPositionType.after,
    template
  );

  // Name the worksheet using the current date.
  let date = new Date(Date.now());
  newSheet.setName(`${date.toDateString()}`);
}

Campos

after
before
beginning
end
none