CODEWITHSUNDEEP
reactjsbracketsexceljsdefined
TheSun
TheSun

Reputation: 11

How to add a Defined Name with square brackets ([]) in ExcelJS?

I am using ExcelJS to create an Excel file and want to add a Defined Name that references a table column. However, when I try to add a name with square brackets ([]), it does not work.

Here is my code:

workbook.definedNames.add(
    'Book[Code]', // This does not work
    'NameBook'
);

I understand that in Excel, a table column reference is usually written as TableName[ColumnName], but it seems that ExcelJS does not accept square brackets ([]) in the defined name.

Any guidance would be appreciated. Thanks! 😊

Upvotes: 0

Views: 8

Answers (0)

Related Questions