Define name cannot exist in xls format but in xlsx format can exist
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
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?
Deleting a branch is permanent. It CANNOT be undone. Continue?