wood burning stoves 2.0*
The moose likes Beginning Java and the fly likes validate an excelsheet entries using java code Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "validate an excelsheet entries using java code" Watch "validate an excelsheet entries using java code" New topic
Author

validate an excelsheet entries using java code

debashis mehta
Greenhorn

Joined: Dec 22, 2010
Posts: 1
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
Marshal

Joined: Mar 22, 2005
Posts: 41106
    
  45
Libraries like jExcelApi and Apache POI can read Excel files.


Ping & DNS - my free Android networking tools app
Seetharaman Venkatasamy
Ranch Hand

Joined: Jan 28, 2008
Posts: 5575

Welcome to JavaRanch debashis mehta
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: validate an excelsheet entries using java code
 
Similar Threads
Excelsheet content reading
EJB References question/ why this answer?
retrieving data from a databse into an excelsheet
Read data from ExcelSheet
How To Comapre To Excelsheet