• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to read a Date column from an Excel sheet using Apache POI

 
GNS GNS
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have an excel sheet which has a Date column whose cell type is custom d-mmm-yy.
When i read this excel using apache POI then this column gets read as a numeric cell and returns the big decimal value.

Is there any way of identifying the cell type to be Date for this custom format?

thanks,
GNS
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello "GNS GNS"-

Welcome to JavaRanch.

On your way in you may have missed that JavaRanch has a policy on display names, and yours does not comply with it; specifically, a first name and a last name are required. Please adjust it accordingly, which you can do right here. Thanks for your prompt attention to this matter.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic