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) + "')");
                    System.out.println();
            }
    }

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

111223361
111223362
111223364
111223363
111223366

It reads them as the following

1.11223361E8
1.11223362E8
1.11223364E8
1.11223363E8
1.11223366E8

Why is this happening and how do i solve it?

Answers


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.