Function cleanColumns

  • cleanColumns(ws, columns, startRow?): void

  • Clears the values of specified columns in all rows starting from a specific row number.

    Parameters

    • ws: Worksheet

      The worksheet containing the rows and columns.

    • columns: string[]

      An array of column identifiers to be cleared (e.g., ['C', 'D', 'E', 'AA']).

    • OptionalstartRow: number = 1

      The row number to start clearing from (default is 1).

    Returns void

    Example

    cleanColumns(worksheet, ['C', 'D', 'E', 'AA', 'AD', 'AF', 'AH'], 5);

Settings