Java & Excel: value being read wrong

I am parsing data from an excel file and adding it to my data base using HSSFCell to parse the Excel file, I am using the following code to read the file

public void printCellDataToConsole(Vector dataHolder) throws SQLException {
            // this is for the rows in the file, set to one to skip the headings
            List<String> studentInformation = new ArrayList<>();
            for (int i = 1; i < dataHolder.size(); i++) {
                    Vector cellStoreVector = (Vector) dataHolder.elementAt(i);
                    // this is for the colums in the table
                    for (int j = 0; j < cellStoreVector.size(); j++) {
                            HSSFCell myCell = (HSSFCell) cellStoreVector.elementAt(j);
                            String stringCellValue = myCell.toString();
                            System.out.print(stringCellValue + "\t");                  
                    connectToDatabase.ammendTableInDatabase("INSERT INTO Student VALUES (" + cellStoreVector.get(0) + ",'" + cellStoreVector.get(1) + "','" + cellStoreVector.get(2) + "','" + cellStoreVector.get(3) + "','" + cellStoreVector.get(4) + "'," + cellStoreVector.get(5) + ",'" + cellStoreVector.get(6) + "')");

Everything is working but when i try to read any value like the following


It reads them as the following


Why is this happening and how do i solve it?


1.11223361E8 means 1.11223361 x (10 ^ 8), so 111223361 = 1.11223361E8...

If you want to get it well formatted, use Double.valueOf("1.11223361E8").longValue().

Need Your Help

Please assist in discovering error in MATLAB function

database matlab loops optimization struct

I am taking a MATLAB programming class and we are currently working on a project which uses a database called Project2 of several structs of airline flight data (all 1 x N). One exercise requires u...

reading json result from ajax odata call

jquery ajax json wcf odata

I am making a call to my oData WCF service hosted on my local PC and the result I get when I pass result to alert box is [object object].

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.