Function: cleanColumns()

function cleanColumns(
   ws: Worksheet, 
   columns: string[], 
   startRow?: number): void;

Defined in: packages/excel-tools/lib/excel.d.ts:79

Clear the values of specified columns starting from a given row.

Parameters

Parameter	Type	Description
ws	Worksheet	The worksheet containing the rows and columns.
columns	string[]	Column letters to clear (e.g., ['C', 'D', 'AA']).
startRow?	number	The row number to start clearing from. Defaults to 1.

Returns

void

Example

const worksheet = workbook.getWorksheet('Transactions');
cleanColumns(worksheet, ['C', 'D', 'E', 'AA', 'AD'], 5);