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) >= TODATE()" ref="Template!A9:F9">
<area ref="Template!A18:F18"/>
<area ref="Template!A9:F9"/>
</if>
</area>