howto read data from excel and write those details to a particular login form

[aryas...@gmail.com]

Hi all,

I am new to selenium webdriver and I have a doubt to read data using excel and write it to a particular user login form.
Kindly provides if you have any.

Thanks in advance

Arya

[DT]

Selenium is web automation framework, it doesn't have any out-of-box Excel bindings so you should take a look at external libraries. So the approach will vary depending on the programming language you are using.

For instance for Java there is Apache POI project which provides read/write functionality on the Microsoft Office document formats. 

Minimal working code to get A1 cell value from "Sheet1" would look like:

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public static void main (String [] argv) throws Exception {
InputStream in = new ByteArrayInputStream(data);
Workbook wb = new XSSFWorkbook(in);
in.close();
Sheet sheet1 = wb.getSheet("Sheet1");
Row row = sheet1.getRow(0);
Cell a1 = row.getCell(0);
System.out.println(a1.getStringCellValue());
}

References:

• Busy Developers' Guide to HSSF and XSSF Features - quick how-to on working with Excel from Java code
  
• How to Extract Data From Files With JMeter - the above code snippet is from that article
  
• TestNG Data Provider with Excel - an example of performing Excel-based data-driven testing