ExcelScript.TableColumn interface

Supprime la colonne du tableau.

delete(): void;

Retours

Exemples

/**
 * This script removes a specific column from a table.
 */
function main(workbook: ExcelScript.Workbook) {
    // Get the table named "Inventory".
    const table = workbook.getTable("Inventory");

    // If it exists, remove the column named "Category".
    let categoryColumn = table.getColumnByName("Category");
    if (categoryColumn) {
        categoryColumn.delete();
    }
}

Récupère le filtre appliqué à la colonne.

getFilter(): Filter;

Retours

Exemples

/**
 * This script adds a table filter to only show the top 10% of values 
 * belonging to a particular column.
 */
function main(workbook: ExcelScript.Workbook) {
    // Get the first table on the current worksheet.
    const table = workbook.getActiveWorksheet().getTables()[0];

    // Get the filter for the "PageViews" table column.
    const pageViewFilter = table.getColumnByName("PageViews").getFilter();

    // Apply a filter to only show the rows with the top 10% of values in this column.
    pageViewFilter.applyTopPercentFilter(10);
}

Obtient l’objet de plage associé à la ligne d’en-tête de la colonne.

getHeaderRowRange(): Range;

Retours

Renvoie une clé unique qui identifie la colonne du tableau.

getId(): number;

Retours

Renvoie le numéro d’indice de la colonne dans la collection de colonnes du tableau. Avec indice zéro.

getIndex(): number;

Retours

Spécifie le nom de la colonne de table.

getName(): string;

Retours

Renvoie l’objet de plage associé à l’intégralité de la colonne.

getRange(): Range;

Retours

Obtient l’objet de plage associé au corps de données de la colonne.

getRangeBetweenHeaderAndTotal(): Range;

Retours

Exemples

/**
 * This script adds a new column to a table.
 * It then sets the formulas in the new column to be the product
 * of the values in the two preceding columns.
 */
function main(workbook: ExcelScript.Workbook) {
  // Get the first table in the workbook.
  const table = workbook.getTables()[0];

  // Append an empty column to the table with the header "Total". 
  const totalColumn = table.addColumn(-1, null, "Total");

  // Get the names of the two preceding columns.
  const productColumnName1 = table.getColumns()[totalColumn.getIndex() - 1].getName();
  const productColumnName2 = table.getColumns()[totalColumn.getIndex() - 2].getName();
  
  // Set the formulas in the "Total" column to be the product of the two preceding columns.
  totalColumn.getRangeBetweenHeaderAndTotal().setFormula(
    `=[@[${productColumnName1}]]*[@[${productColumnName2}]]`
  );
}

Obtient l’objet de plage associé à la ligne de total de la colonne.

getTotalRowRange(): Range;

Retours

Exemples

/**
 * This script logs the value in the total row of a table column.
 */
function main(workbook: ExcelScript.Workbook) {
    // Get the table named "Cities".
    const table = workbook.getTable("Cities");

    // Get the total row from the "Population" column.
    const column = table.getColumn("Population");
    const totalRange = column.getTotalRowRange();

    // Log the total value.
    console.log(totalRange.getValue());
}

Spécifie le nom de la colonne de table.

setName(name: string): void;

Paramètres

Retours

Exemples

/**
 * This script renames a column in an existing table.
 */
function main(workbook: ExcelScript.Workbook) {
  // Get the "Employee" table.
  const employeeTable = workbook.getTable("Employee");

  // Rename a column from "EmplID" to "Employee ID".
  const idColumn = employeeTable.getColumnByName("EmplID");
  idColumn.setName("Employee ID");
}