How to insert output values into the Excel through WebDriver.

[Yogesh Tyagi]

Hi All,

Please help me out on bellow mentioned point:

How to insert output values into the Excel through WebDriver.



Regards,
Yogesh

[vishnu]

Remember, WebDriver is an API to interact with browser and just that, nothing to do with Excel parsing. Similarly there would be APIs to interact with Excel, choose the one based on your preferred programming language.

For example, for C# implementation you can take a look at NPOI.

Thanks,

Vishnu

[rafiuddin shaik]

Hi Yogesh!

I am putting up the workable code of extracting from the list

you might have to create a user name and password for this code to work

at salesforce.com

package com.cybersysit.demo;

import java.io.File;
import java.io.IOException;
import java.util.List;
import java.util.concurrent.TimeUnit;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.openqa.selenium.support.ui.Select;

import com.google.common.collect.ArrayListMultimap;
import com.google.common.collect.Multimap;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class JXL_ExcelWriter {

    /**
     * @learn selenium from cybersysit.com
     * @
     */
    WebDriver driver;
    public void launch_browser(){
        driver = new FirefoxDriver();
        driver.get("http://www.salesforce.com/in/?ir=1");
        driver.findElement(By.xpath("//*[@id='button-login']")).click();
        driver.findElement(By.xpath("//*[@id='username']")).sendKeys("username");
        driver.findElement(By.xpath("//*[@id='password']")).sendKeys("password");
        driver.findElement(By.xpath("//*[@id='Login']")).click();
    }
   
    public void populateList() throws IOException, RowsExceededException, WriteException{
        String filePath = "D:\\ChilakalagudaJava\\SalesForceDemo\\industryList.xls";
        File file = new File(filePath);
        WritableWorkbook workBook = Workbook.createWorkbook(file);
        WritableSheet sheet = workBook.createSheet("writework", 0);
       
       
       
        driver.manage().timeouts().implicitlyWait(100, TimeUnit.SECONDS);
        //lead creation
        driver.findElement(By.xpath("//*[@id='Lead_Tab']/a")).click();
   
        //click new lead button
        driver.findElement(By.xpath("//*[@id='hotlist']/table/tbody/tr/td[2]/input")).click();
       
        WebElement listIndustry = driver.findElement(By.id("lea6"));
        Select selectIndustry = new Select(listIndustry);
        List <WebElement>listindustry = selectIndustry.getOptions();
        int column=0;
        for(int y=0;y<listindustry.size();y++){
            String listindust = listindustry.get(y).getText();
            System.out.println("industry List"+listindust);
            Label indLabel = new Label(column,y,listindust);   
            System.out.println("y ................."+y);
            sheet.addCell(indLabel);
       
           
        }
        workBook.write();
        workBook.close();
    }

    public static void main(String[] args) throws IOException, RowsExceededException, WriteException {
        // TODO Auto-generated method stub
        JXL_ExcelWriter Obj = new JXL_ExcelWriter();
        Obj.launch_browser();
        Obj.populateList();
       
    }

}

--
You received this message because you are subscribed to the Google Groups "Selenium Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to selenium-user...@googlegroups.com.
To post to this group, send email to seleniu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/selenium-users/8088707c-ac55-4c74-bc2d-ee7395cb52e5%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

[nani.thrinath.info]

Use Follows FileOutputStream fo = new FileOutputStream("D:\\eclipse\\workspace\\Selenium_Project\\Results\\Results.xls");

WritableWorkbook wb=Workbook.createWorkbook(fo);

WritableSheet ws=wb.createSheet("Results", 0);

Label un=newLabel(0, 0, "UserName");

Label pw=newLabel(1, 0, "Password");

Label rslt=newLabel(2, 0, "Result");

ws.addCell(un);

ws.addCell(pw);

ws.addCell(rslt);

wb.write();

wb.close(); Regards, Thrinath

To view this discussion on the web visit https://groups.google.com/d/msgid/selenium-users/CA%2BUbb23jW-X9Jzx6h%3DMbU7Ng2bAR6v_OWodSj10vhcLQw9rDrQ%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Thrinath

[Panikera Raj]

Hi Shaik,

 

Can we update excel sheet which is already created(like uppending text to the excel )

 

Regards,

Panikera

To view this discussion on the web visit https://groups.google.com/d/msgid/selenium-users/CACy7ZuH2nabD2GscjygKF6joFjgXEXifStPMBYnHxdopLL7gog%40mail.gmail.com.

[nani.thrinath.info]

yes, you can update!

To view this discussion on the web visit https://groups.google.com/d/msgid/selenium-users/CAEzR4ZzaoPeYaYOJ2NU0Cck_x-fqw%2B1nEeGbyUZt9ch3GdL2pA%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Thrinath

[Panikera Raj]

Hi Nani,

Can you provide sample snippet for to Update excel file

 

Regards,

Panikera

To view this discussion on the web visit https://groups.google.com/d/msgid/selenium-users/CACy7ZuEhtzayNL6wHNvwFSUq0yvCLK-uG88yTi%3DpNLmqkx6EJw%40mail.gmail.com.

[Krishnan Mahadevan]

Guys!!

This is a Selenium/WebDriver forum. Please help keep this forum relevant by posting queries related to it.

You might as well take this offline amongst yourselves !

Thanks in advance for your understanding

Thanks & Regards
Krishnan Mahadevan

"All the desirable things in life are either illegal, expensive, fattening or in love with someone else!"
My Scribblings @ http://wakened-cognition.blogspot.com/

To view this discussion on the web visit https://groups.google.com/d/msgid/selenium-users/CAEzR4Zx1Az1A7dhkXacuu-%2BAzSfv2qCh%2Bdafkm%2BVjPPznMoB1A%40mail.gmail.com.

[nani.thrinath.info]

FileOutputStream fo = new FileOutputStream("D:\\eclipse\\workspace\\Selenium_Project\\Results\\Results.xls");

WritableWorkbook wb=Workbook.createWorkbook(fo);

WritableSheet ws=wb.createSheet("Results", 0);

Label un=newLabel(0, 0, "UserName");

Label pw=newLabel(1, 0, "Password");

Label rslt=newLabel(2, 0, "Result");

ws.addCell(un);

ws.addCell(pw);

ws.addCell(rslt);

wb.write();

wb.close(); Regards, Thrinath

To view this discussion on the web visit https://groups.google.com/d/msgid/selenium-users/CAEzR4Zx1Az1A7dhkXacuu-%2BAzSfv2qCh%2Bdafkm%2BVjPPznMoB1A%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Thrinath

[Ashok kumar]

Hi,

If you would prefer working with POI(which is widely used now) , download the Data Driven Framework from below link to write data to Excel. Using this you can write data in an existing excel file.

Download From: http://automationtestingutilities.blogspot.in/

For writing data, you would use the below code snippet.

String excelResource = "ExcelTestData.xlsx"; 
ExcelRuntimeOutput writer = new ExcelRuntimeOutput( 
excelResource); 
writer.backupExcel(); 
writer.setValueAt("SheetName", 0, 0, "MyDataAtFirstRowFirstColumn"); 
writer.setValueAt("SheetName", 0, 1, "MyDataAtFirstRowSecondColumn"); 
writer.generateExcel();

The Sample Project has the code that explains how to write to excel.

Regards 
Ashok