• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

validate an excelsheet entries using java code

 
debashis mehta
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI Experts,

I have a requirement in which i need to validate the excelsheet entries for two conditions:-1)for null values(empty values) of column entries 2)for incorrect datatype for the column entries.Suppose there are two columns:-

1)Emp Number
2)Emp Name

Emp Number is of float datatype(suppose) now if the user is entering the values as integer or date then this values needs to be validated .The incorrect datatype values should be displayed.

Can anyone provide me a sample code for this .This will be of great help...

Thanks and Regards
Debashis
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Libraries like jExcelApi and Apache POI can read Excel files.
 
Seetharaman Venkatasamy
Ranch Hand
Posts: 5575
Eclipse IDE Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to JavaRanch debashis mehta
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic