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!


Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.