Function: cleanColumns()

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

Defined in: src/excel/excel.tsx:151

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

Parameters

Parameter	Type	Default value	Description
ws	Worksheet	undefined	The worksheet containing the rows and columns.
columns	string[]	undefined	Column letters to clear (e.g., ['C', 'D', 'AA']).
startRow	number	1	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);