Hi ,
I used this code but i m not getting hw to fetch data from Excel file,where exectly we have to make changes plz let me know
1)I have changed URL and Excel path then what i have to change .
package package1;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
public class yoda2 {
public static void main(String[] args) {
// Launch FireFox WebDriver driver = new FirefoxDriver();
System.setProperty("webdriver.chrome.driver","./drivers/chromedriver.exe");
WebDriver driver;
driver=new ChromeDriver();
driver.manage().window().maximize();
// Enter YODA URL
// Enter UserID
driver.findElement(By.name("userid")).sendKeys("xx3517");
// Enter Password driver.findElement(By.name("password")).sendKeys("123123a");
// Click on Submit button after entering User ID and Password driver.findElement(By.name("btnSubmit")).click();
// Click on Remind Me later driver.findElement(By.name("successOK")).click();
try { File file = new File("E:\\MFB_NEW_WS\\new3\\Soma\\Excelfile\\Login_ExcelSheet.xlsx");
FileInputStream iFile = new FileInputStream(file);
XSSFWorkbook wb = new XSSFWorkbook(iFile);
XSSFSheet sheet = wb.getSheet("Sheet1");
int rowCount = sheet.getLastRowNum();
System.out.println("the no of rows are : " + rowCount);
for (int row=1; row<=rowCount; row++)
{ String location = sheet.getRow(row).getCell(0).getStringCellValue();
String activity = sheet.getRow(row).getCell(1).getStringCellValue();
int order=(int) sheet.getRow(row).getCell(2).getNumericCellValue();
System.out.println(location + " , " + activity + " , " +order );
}
iFile.close();
}
catch (IOException e) { e.printStackTrace();
}
// Click on Search Button on YODA home page
driver.findElement(By.className("MenuBarItemSubmenu")).click();
driver.findElement(By.xpath("//*[text()='Fulfillment Details']")).click();
driver.findElement(By.name("location")).sendKeys(location);
driver.findElement(By.name("activity")).sendKeys(activity);
driver.findElement(By.name("orderID")).sendKeys(order);
driver.findElement(By.id("fulfillment_submit")).click(); } }
Advance Thanks
Somu