View all xlsx analysis

How to use the xlsx.utils.aoa_to_sheet function in xlsx

To help you get started, we’ve selected a few xlsx examples, based on popular ways it is used in public projects.

Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.

Enalean / tuleap / plugins / testplan / scripts / test-plan / src / helpers / Export / transform-report-to-xlsx-sheet.ts View on Github

export function transformAReportIntoASheet(report: ExportReport): WorkSheet {
    const cells = transformSectionsIntoSheetRows(report.sections);
    const worksheet = utils.aoa_to_sheet(transformSectionsIntoSheetRows(report.sections));
    worksheet["!cols"] = fitColumnWidthsToContent(cells);
    worksheet["!merges"] = createMerges(cells);

    return worksheet;
}