Matterway
    Preparing search index...

    Function cleanColumns

    • 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

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

    Settings