Define name cannot exist in xls format but in xlsx format can exist #2813

I've already set define name in my workbook, but when i create excel file on xls format, define name can't exist after write file. Anyone can help me to solve this issue ? thanks!

note: format file should be xls

I've already set define name in my workbook, but when i create excel file on xls format, define name can't exist after write file. Anyone can help me to solve this issue ? thanks! note: format file should be xls

code_define_name.PNG

17 KiB

define_excel.PNG

17 KiB

Defined names are not currently written for the BIFF8 XLS format. We do plan on addressing it when we revisit formulae (since they use the same infrastructure)

any alternative solution for setting define names on the XLS Format? or any version of sheetjs/xlsx from npm package that support define names for the XLS format?

any version of sheetjs/xlsx from npm package that support define names for the XLS format?

Labels Milestones

Define name cannot exist in xls format but in xlsx format can exist #2813