exceljs / exceljs/exceljs

Error: Worksheet name already exists: My Sheet

Open
#910 10 comments 0 reactions 0 assignees View on GitHub
bug i18n
Dominant language
JavaScript
Stars
15.5k
Forks
2k
PR merge metrics
No merged PRs in 30d

Description

Error: Worksheet name already exists: My Sheet

var Excel = require('exceljs');

function test(invoices) {

var workbook = new Excel.Workbook();

var worksheet = workbook.addWorksheet('My Sheet');

worksheet.getRow(1).font = { bold: true };
worksheet.getRow(1).alignment = { horizontal: 'center', vertical: 'middle', wrapText: true };
worksheet.getColumn('B').alignment = { horizontal: 'center' };
worksheet.getCell('A1').value = 'Invoice Number';
worksheet.getCell('B1').value = 'Invoice Total';
worksheet.getColumn('A').width = 15;
worksheet.getColumn('B').width = 10;

for (var i = 0; i < invoices.length; i++) {

worksheet.getCell('A' + (i + 2)).value = invoices[i].InvoiceNumber;

worksheet.getCell('D' + (i + 2)).value = invoices[i].InvoiceTotal;

}

return workbook;

}

It's working on ExcelJS version 10.0.0 but when update to new version of ExcelJS (1.14.0) getting this error

Node version : 12.6.0

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.