title: How to read excel data in java, selenium testing?
body: <p>I have a selenium webdriver backed code in java for testing an web application. My code is given below: </p>
  
  <pre><code>package testcases;
  
  import com.thoughtworks.selenium.Selenium;
  import org.openqa.selenium.firefox.FirefoxDriver;
  import org.openqa.selenium.WebDriver;
  import org.openqa.selenium.WebDriverBackedSelenium;
  import org.junit.After;
  import org.junit.Before;
  import org.junit.Test;
  import static org.junit.Assert.*;
  import java.util.regex.Pattern;
  
  public class Untitled {
  private Selenium selenium;
  
  @Before
  public void setUp() throws Exception {
          WebDriver driver = new FirefoxDriver();
          String baseUrl = "http://www.himalayanpalmistry.com/";
          selenium = new WebDriverBackedSelenium(driver, baseUrl);
  }
  
  @Test
  public void testUntitled() throws Exception {
          selenium.open("/mabiz/");
          selenium.select("id=register_type", "label=für Unternehmen");
          selenium.click("id=rgst");
          selenium.waitForPageToLoad("30000");
          selenium.type("id=username", "javatesting1");
          selenium.type("id=password", "12345678");
          selenium.type("id=confirm_password", "12345678");
          selenium.type("id=name", "java testing");
          selenium.type("id=position", "java testing");
          selenium.type("id=company", "java testing");
          selenium.type("id=address", "java testing");
          selenium.type("id=zipcode", "12345");
          selenium.type("id=city", "safdj");
          selenium.type("id=phone", "kfajs");
          selenium.type("id=email", "tsandesh23@hotmail.com");
          selenium.click("id=show_contact_info");
          selenium.click("id=product_select3");
          selenium.click("id=term_condition1");
          selenium.click("name=submit_one");
          selenium.waitForPageToLoad("30000");
  }
  
  @After
  public void tearDown() throws Exception {
          selenium.stop();
  }
  }
  </code></pre>
  
  <p>I want to modify this code for reading microsoft excel data and do many tests by this code. My excel file contains various test data. Thanx in advance!!</p>