Fetching data from excel sheet from Java?

Answer 1

The Apache POI project is a Java API to read and write Microsoft Documents.

The API allows you can read and write MS Excel files using Java.

Answer 2

I have used below listed libraries for writing/reading excel files in my java project.

Those libraries are supporting even bigger excel files, I am using more than one lakh records for uploading and downloading without any issue.

• poi-ooxml-3.17.0.wso2v1.jar
• poi-3.8.jar
• xmlbeans-2.3.0.jar
• commons-collections4-4.1.jar

Please find the sample code in Java

import Java.io.FileInputStream;

import Java.io.FileNotFoundException;

import Java.io.IOException;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.Iterator;

import java.util.List;

import java.util.Map;

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 class ExcelReadColumns {

public static void main(String[] args) {

excelReadColumns("C:\My Projects\TestSample.xlsx");

}

public static String excelReadColumns(String fileName){

String processStatusFlag="NULL";

List longURLList = new ArrayList();

FileInputStream fileInputStream = null;

try {

fileInputStream = new FileInputStream(fileName);

// Using XSSF for xlsx format, for xls use HSSF

Workbook workbook = new XSSFWorkbook(fileInputStream);

Sheet sheet = workbook.getSheetAt(0);

Iterator rowIterator = sheet.iterator();

for (int i = 1; i