JXLS: How to add If-command condition for date column in XML markup

425 views Asked by At

I am using XML markup to use JXLS library. I I have defined the XML file but I am not sure how to add condition for date; I want to compare if the endDate column value is <= today's date.

I tried the below code but is is not working:

<area ref="Template!A9:F9">
    <if condition="DATEVALUE(countryGrid.endDate) &gt;= TODATE()" ref="Template!A9:F9">
        <area ref="Template!A18:F18"/>
        <area ref="Template!A9:F9"/>
    </if>
</area>
0

There are 0 answers