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




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


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

<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:set value="${creation_dt.toString()}" var="creation_dt"/>