validate an excelsheet entries using java code

[debashis mehta]

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]

Libraries like jExcelApi and Apache POI can read Excel files.

[Seetharaman Venkatasamy]

Welcome to JavaRanch debashis mehta