AnsweredAssumed Answered

Read Date Column from .xls in Gel

Question asked by lakse01 Employee on Oct 2, 2018
Latest reply on Oct 8, 2018 by lakse01

Hi Team

 

I am trying to read the date column from excel (.xls). But the timestamp has truncated and shows the data "03-Aug-2018".

 

It would be great, how can read date column from excel in gel script

 

Data from Input file:

 

03/08/2018 03:13:21

 

Code:

 

<core:catch var = "xssfexp">
<core:new className = "org.apache.poi.hssf.usermodel.HSSFWorkbook" var = "varxssfwb">
<core:arg type = "java.io.FileInputStream" value = "${varFileisInstance}"/>
</core:new>
</core:catch>

 

<core:invoke method = "getSheetAt" on = "${varxssfwb}" var = "varSheet">
<core:arg type = "java.lang.Integer" value = "0"/>
</core:invoke>

<core:set value = "${varSheet.getPhysicalNumberOfRows()}" var = "rowCount"/>
<gel:log>Number of Rows in Sheet: ${rowCount}</gel:log>

 

 

<core:invoke method = "getCell" on = "${cur_row}" var = "creation_dt">
<core:arg type = "java.lang.Integer" value = "${0}"/>
</core:invoke>

 

 

<core:set value="${creation_dt.toString()}" var="creation_dt"/>

Outcomes