SELENIUM JAVA : APACHE POI API to Read and Write data into Excel File using Java

SELENIUM JAVA : APACHE POI API to Read and Write data into Excel File using Java

SDET Automation Testing Interview Questions & Answers

We will be covering a wide range of topics including QA manual testing, automation testing, Selenium, Java, Jenkins, Cucumber, Maven, and various testing frameworks.

APACHE POI API to Read and Write data into Excel File using Java

Apache POI is a Java API that allows developers to read and write Microsoft Office documents, including Excel. Here are the steps to read and write data into an Excel file using Apache POI API in Java:

Add the Apache POI dependency to your project. You can download the latest version of Apache POI from their official website or add it as a Maven dependency.

Create an instance of the Excel workbook and open the Excel file using the following code:

Workbook workbook = new XSSFWorkbook(fis);

To read data from the Excel file, you can use the following code:

In this code, rowNum and cellNum represent the row and column numbers, respectively.

To write data to the Excel file, you can use the following code:

In this code, rowNum and cellNum represent the row and column numbers, respectively, and cellValue represents the data to be written to the cell.

After you have finished reading or writing data to the Excel file, you should close the workbook and the input stream using the following code:

These are the basic steps to read and write data into an Excel file using Apache POI API in Java. There are many other features that Apache POI provides, such as formatting cells, applying formulas, and creating charts. You can explore these features in the official Apache POI documentation.

[sdet_automation_testing]

APACHE POI API to Read and Write data into Excel File using Java

Apache POI is a Java API that allows developers to read and write Microsoft Office documents, including Excel. Here are the steps to read and write data into an Excel file using Apache POI API in Java:

Add the Apache POI dependency to your project. You can download the latest version of Apache POI from their official website or add it as a Maven dependency.

Create an instance of the Excel workbook and open the Excel file using the following code:

FileInputStream fis = new FileInputStream(new
Workbook workbook = new XSSFWorkbook(fis);
Sheet sheet = workbook.getSheetAt(0);

To read data from the Excel file, you can use the following code:

Row row = sheet.getRow(rowNum);
Cell cell = row.getCell(cellNum);
String cellValue = cell.getStringCellValue();

In this code, rowNum and cellNum represent the row and column numbers, respectively.

To write data to the Excel file, you can use the following code:

Row row = sheet.createRow(rowNum);
Cell cell = row.createCell(cellNum);
cell.setCellValue(cellValue);

In this code, rowNum and cellNum represent the row and column numbers, respectively, and cellValue represents the data to be written to the cell.

After you have finished reading or writing data to the Excel file, you should close the workbook and the input stream using the following code:

fis.close();
workbook.close();

These are the basic steps to read and write data into an Excel file using Apache POI API in Java. There are many other features that Apache POI provides, such as formatting cells, applying formulas, and creating charts. You can explore these features in the official Apache POI documentation.