Kaizen
Browse modulesInsightsinsights/serverFunctions

Function: sanitizeSheetName()

function sanitizeSheetName(name: string): string;

Defined in: server/insights/export/xlsx.ts:162

Excel-legal, length-limited worksheet name.

Beyond the illegal-character set, Excel (and exceljs's addWorksheet validation) also rejects a name that STARTS OR ENDS with an apostrophe — inner apostrophes are fine. Stripped after the length slice, because slicing to 31 characters can itself expose a trailing apostrophe.

Parameters

ParameterType
namestring

Returns

string

On this page