Help in reading mobile number

[pooja prabhu]

hi

Can Anyone please tell me how to read mobile number example:9823145678 in java from excel

Thank you

[James Peterson]

Hi Pooja,

if you know how to read a excel file then you can do it by giving a condition to read only mobile number column from excel file.

Regards,
James

[pooja prabhu]

Thanks James
Actually i am new to java so can you elaborate?
Can You Tel Me how to do it..

[Ulf Dittmer]

What do you have so far, and where are you stuck making progress? If you haven't started, then you should get familiar with the Apache POI library for reading Excel files.

[pooja prabhu]

yes i have already started
I take file name from text box

   String file_nm=filename.getText();
                                PreparedStatement pstm = null ;
                                FileInputStream input = new FileInputStream(file_nm);
                                POIFSFileSystem fs = new POIFSFileSystem( input );
                                HSSFWorkbook wb = new HSSFWorkbook(fs);
                                HSSFSheet sheet = wb.getSheetAt(0);
                               HSSFRow row;
                               HSSFCell cell;
                               int rows;
                               rows=sheet.getPhysicalNumberOfRows();
            
                              
                                for(int i1=sheet.getFirstRowNum(); i1<rows; i1++)
                                {
//                                    if(i1==0)
//                                    {
//                                        
//                                       
//                                    }
//                                    else
//                                    {
                                        row = sheet.getRow(i1);
                                        
                                    System.out.println(sheet.getLastRowNum());
                                  int id = (int) row.getCell(0).getNumericCellValue();
                                    String person_name = row.getCell(1).getStringCellValue();
                                    String person_email= row.getCell(2).getStringCellValue();
                                    int person_mobile= (int) row.getCell(3).getNumericCellValue();
                                    String message= row.getCell(4).getStringCellValue();
                                //String Date=row.getCell(5).getStringCellValue();
                                // System.out.println(Date)
                                  
                   // String strCellValue = new String(Date.toString());
                    
//                                    SimpleDateFormat simpledate= new SimpleDateFormat("yyyy-MM-dd");
//                                    String f2=  simpledate.format(Date);
//                                    String y= f2.substring(0,4);    
//                                    String m= f2.substring(5,7);
//                                    String d= f2.substring(8,10); 
//                                    String dates=y+"-"+m+"-"+d+" 00:00:00";
                                 
                                    String sql = "INSERT INTO temp_person_details VALUES('"+id+"','"
                                            + ""+person_name+"','"+person_email+"','"+person_mobile+"'"
                                            + ",'"+message+"')";
                                    pstm = (PreparedStatement) MySqlConnection.conn().prepareStatement(sql);
                                    pstm.execute();
                                  //  }
                                } 

[Ulf Dittmer]

So what's still missing?

[pooja prabhu]

i cant read correct mobile number. it saves 2147483647 instead of mobile number

[Ulf Dittmer]

You're treating the phone number as an integer, whereas you should be treating it as a string.

[pooja prabhu]

i had tried it it gives me exception

java.lang.IllegalStateException: Cannot get a text value from a numeric cell

[Ulf Dittmer]

Then you need to change the spreadsheet so it doesn't format that field as a number. Phone numbers are strings, not numbers.

[pooja prabhu]

what will be the format?

[Ulf Dittmer]

Which options do you see? Which one do you think makes sense?