How to use Excel formula for template field

Posted by: supply on 23 May 2023, 11:18 pm EST

    • Post Options:
    • Link

    Posted 23 May 2023, 11:18 pm EST

    Hi, please help with my request.

    I use a template to get Excel document. One field in datasource represents a date in ISO format. I’d like to insert as the date, e.g. I’m going to use Excel formula (DATEVALUE). But I cannot find a way to specify the formula in my template.

    I’ve tried the following expressions

    • {{==DATEVALUE({{field}}) }}
    • =DATEVALUE({{field}})

    Is there a proper way to get what I want?

    P.S. We have bought the license.

  • Posted 24 May 2023, 10:41 pm EST

    Hello,

    Apologies for the inconvenience caused.

    There is no direct way to apply the formula with the field name in the template but you can use the cell address in with the formula in the template cell. Please see the attached template and sample implementing the same.

    You can hide the column with the actual data if you do not want to show it.

    If you have some other requirement then please explain us in brief.

    Regards,

    Prabhat Sharma.

    DataTable_csharp_Modified.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels