Write Data To Excel Using Column Name

Publicado el: 05 enero 2017
en el canal de: Krishna Sakinala (Automation Testing)

18,667

112

Please use the following link to install the Katalon Studio:

https://katalon.com/sign-up?getr=kris... Check Tubebuddy Features Here:
https://www.tubebuddy.com/krishnasaki... Facebook : / automationtesting2016
Linkedin : / krishnasakinala
Google+ : https://plus.google.com/1052863009260...
Twitter : https://www.linkedin.com/feed/?trk=hb...
http://automationtesting.in/write-dat...

Write data to excel using column name will discuss about how we can write test data/test results to the excel sheet while automating any application using selenium web driver. We might get doubt that why we need to put the test results in excel. If an application need so much of data to be feed to test; then we will manage those data using external sources like text file, xml file and excel file etc… . Among these; Excel is very user friendly that we can organize the data very easily and we can read and write the data how we want. So, we mostly use excel to maintain the test data and results. In order to create a data driven framework then it is easy with using excel.

So, if you want to write data to excel; we need to use some third party API which are available. In those one of the famous is Apache POI. In this blog we will use Apache POI to write the data to the excel sheet. To interact with the excel, Apache POI given so many classes to interact with the excel and read and write the data. To read/write excel data we will use Java and Apache POI classes.

Below are the classes will use to read/write the data:

FileInputStream – A FileInputStream is an inputstream for reading data from a File.
FileOutputStream – A FileOutputStream is an outputstream for writing data to a File.
XSSFWorkbook
XSSFSheet
XSSFRow
XSSFCell
XSSFFont
XSSFCellStyle

Below are the methods will use to read/write the data which are available in the above classes:

getSheet(“sheetName”) – Get sheet with the given name
getLastCellNum() – Get the index of the last cell contained in the row Plus one as index starts from ZERO
setCellValue() – Set the value of the cell
getRow(int) – Returns the row.
getCell(int) – Get the cell representing a given column

En esta página del sitio puede ver el video en línea Write Data To Excel Using Column Name de Duración hora minuto segunda en buena calidad , que subió el usuario Krishna Sakinala (Automation Testing) 05 enero 2017, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 18,667 veces y le gustó 112 a los espectadores. Disfruta viendo!

1,804