Function sortColumns

sortColumns(worksheet, compareFn): void

Sorts worksheet columns based on a custom compare function.

Parameters

worksheet: Worksheet
The ExcelJS worksheet.
compareFn: ((a: any, b: any) => number)
The compare function for sorting.
- - (a, b): number
  - Parameters
    - a: any
    - b: any
    Returns number

Returns void

Example

// Sort columns alphabetically by header
sortColumns(worksheet, (a, b) => String(a).localeCompare(String(b)));

// Sort columns by custom order
sortColumns(worksheet, (a, b) => {
  const order = { 'Name': 1, 'Email': 2, 'Phone': 3 };
  return (order[a] || 999) - (order[b] || 999);
});