Read formulaes from excel | Selenium Forum
M
Posted on 16/12/2015
Hi I have created a Student xlsx file. I have 2 columns:

- SessionStartDate containing =NOW() and
- SessionEndDate which contains =NOW()+90.

When I read it using Xls_Reader getcell data the output is:

Session Start Date is: 16/111/15
Session End Date is: 21/111/15

Can you please help me figuring out whats going on.

Thanks
Rachana

M
Replied on 16/12/2015

poi api cannot read date. convert that to string and then try again.