Function sortColumns

sortColumns(worksheet: Worksheet, compareFn: (a: any, b: any) => number): 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.

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);
});