Add defined names with handlebars-xlsx
-
Hi all,
Background:
I am trying to add cell names (xml <definedNames>) from handlebars into an xlsx.In our use case, it is not possible to store these names to the Excel level because we run logic that removes partials. Upon using logic to remove a partial, the xml retains unhandled <definedNames> and thus breaks the xlsx.
Question:
How can I add a defined Name into an xlsx cell from handlebars? OR to remove definedNames conditionally when they are stored in the xml?I have been looking all over for a similar case with no success so decided to throw this here.
Please note that this is not the cell value but the cell definedName where you can find reference to left of the formula field ribbon. Excel definedNames are stored in xl/workbook.xml
Thank you!