title: Validating data in MS Excel in Java
body: <p>How can I validate every data in Microsoft Excel before I import it in the database using Java? Should I use loops? But wouldn't it take much time in looping all data in the excel? example if i have more than 3000 data in Excel. What is the best way to validate bad user input in excel? For example bad date format or bad employee id format.</p>