Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
» how to connect DB in selenium webriver
Fri Oct 06, 2017 4:09 pm by anbarasi

» How find any text in browser screen and click on it?
Thu Oct 05, 2017 2:02 pm by sandeepkommineni

» Selenium Webdriver
Tue Oct 03, 2017 1:35 pm by PiyushBiswas

» GRID setup tutorial.
Wed Sep 27, 2017 4:29 pm by johnyapp

» Drag & Drop Between Windows Using Selenium Driver
Wed Sep 27, 2017 2:10 pm by 26rondel

» Check if window is closed / verify input
Sat Sep 23, 2017 10:21 pm by brainstir

» How to work on pages with AJAX in selenium?
Mon Sep 18, 2017 6:08 pm by azharuddin

» pause test until user press a key like F2
Wed Aug 09, 2017 11:10 pm by djnforce

» Selecting the input for auto populating element
Sat Jul 29, 2017 7:53 pm by kdabbara

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search

Selenium 2.0 + Excel

View previous topic View next topic Go down

Selenium 2.0 + Excel

Post by peter191 on Sat Jun 08, 2013 5:52 am

Hi,

I am writing the selenium scripts where I am trying to read 16 digit card number from excel sheet.
Excel sheet has 1 column.

For that I have wrote following code.

Code:
public static Vector<Object[]> getCCPayment() throws Exception {
      
      Vector<Object[]>  list = new  Vector<Object[]>();
      File excel = new File("C:/Automation/Koodo_DataDriven/Data/login.xls");
      FileInputStream fis = new FileInputStream(excel);
      HSSFWorkbook wb = new HSSFWorkbook(fis);
      HSSFSheet ws = wb.getSheet("payment");   
      
      for(int c = 0; c<ws.getLastRowNum()+1; c++) {
         HSSFRow row = ws.getRow(c);
         int columnNumber = 1;
         String[] xuser = new String[columnNumber];
         for (int j = 0; j<2; j++ ) {
            HSSFCell paymentcell = row.getCell(j);
            String xvalue = cellToStringPayment(paymentcell);
            xuser[j] = xvalue;
            System.out.println("the value is" + xvalue);            
         }
         list.add(xuser);
      }
   return list;   
}


Upon execution of above code, I am getting following result with error:

the value is1.23456789123456E14
Exception in thread "main" java.lang.NullPointerException
at com.koodomobile.util.ExcelRead.cellToStringPayment(ExcelRead.java:98)
at com.koodomobile.util.ExcelRead.getCCPayment(ExcelRead.java:58)
at com.koodomobile.util.ExcelRead.main(ExcelRead.java:16)


The value in excel file is 123456789123456.
But the value I'm receiving as result is different in decimal with error message? confused

Can somebody help me what's the issue here and how can I solve it?

peter191

Posts : 1
Join date : 2013-06-08

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum