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

New Issue

hasbighifari · 2022-10-17T16:14:53Z

hasbighifari commented

2022-10-17 16:14:53 +00:00

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

sheetjs commented

2022-10-17 18:02:53 +00:00

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)

hasbighifari commented

2022-10-17 22:23:11 +00:00

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?