Writing data into excel using JXL- Selenium(Java)

Question

I am trying to read from webpage and write it to a excel sheet. Below is set of code works fine, but i am not able to figure out how to run this in a loop so that i can wright bulk data. As i have to write many value which i am reading from the table

FileOutputStream fo = new FileOutputStream("D:\\output.xls");
WritableWorkbook wb = Workbook.createWorkbook(fo);
WritableSheet ws = wb.createSheet("customsheet", 1);

This is the content which i am reading from webpage.

String m1 = (driver.findElement(By.xpath(".//*[@id='ctl00_ContentPlaceHolderBody_ucModelDataEntry1_lblPublishedFuelCostPerLoadEstimatedAllInCost']")).getText());
ws.getCell(m1);

You'll need to store the values you get from scraping the web page somewhere. Consider using a Collection class. — Meesh
– Meesh, Commented Oct 16, 2013 at 14:26

Shoaib Shaikh · Accepted Answer · 2014-12-03 10:29:19Z

1

Thanks for all your help But the below code worked for me

String m1 = (driver.findElement(By.xpath(".//*[@id='ctl00_ContentPlaceHolderBody_ucModelDataEntry1_lblPublishedFuelCostPerLoadEstimatedAlInCost']")).getText());
System.out.println(m1);
WritableWorkbook wb = Workbook.createWorkbook(new File("D:\\output_2.xls"));
writableSheet ws = wb.createSheet("customsheet",1);
{
Label label = new Label(0,0,m1);
ws.addCell(label);
}
wb.write();
wb.close();

edited Dec 3, 2014 at 10:29

Shoaib Shaikh

3537 silver badges22 bronze badges

answered Oct 18, 2013 at 5:52

Chaitanya

231 gold badge1 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TheLostMind · Accepted Answer · 2013-10-16 14:45:57Z

0

First read the entire data you want to write.. Then start from a col say 0 , row number =1 - and then start writing data.. If you are storing the data in an arrayList, then

rowNo=1;
for(int colNo=0;colNo<arrList.size();colNo++)
   {
    Cell c = sheet0.getCell(colNo, rowNo);
  //    write data to your cell here... one by one - reading data from arraylist
    }

answered Oct 16, 2013 at 14:45

TheLostMind

36.3k12 gold badges72 silver badges109 bronze badges

Collectives™ on Stack Overflow

Writing data into excel using JXL- Selenium(Java)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related