excel reader in java | java xlsx reader | read xssfworkbook example in java

excel reader in java | java xlsx reader | read xssfworkbook example in java

Here code that read (.xlsx) file get appropriate manner,

it means here only three fields demo but you setup by your custom value datatype and add or delete your required fields.

 Requrie library :  ApachePOI
                             Poi-ooxml (if Xml Error) 

Input File :-

import java.io.File;
import java.io.FileInputStream;
import java.util.Iterator;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 *
 * @author vishal.khokhar
 */
public class ExcelReader {

    public static void main(String[] args) throws Exception {
        ExcelReader excelReaderObj = new ExcelReader();
        excelReaderObj.readxlsx();
    }

    public void readxlsx() {
        try {
            File myFile = new File("/home/vishal.khokhar/Demo.xlsx");

            FileInputStream fi = new FileInputStream(myFile);

            //take workbook for XLSX file
            XSSFWorkbook workBook = new XSSFWorkbook(fi);

            // take first sheet from XLSX workbook
            XSSFSheet mySheet = workBook.getSheetAt(0);

            // Get iterator to all the rows in current sheet
            Iterator<Row> rowIterator = mySheet.iterator();

            // iterate over each row file
            String pinNumber = "";
            String pattern = "";
            String amount = "";

            while (rowIterator.hasNext()) {
                Row row = rowIterator.next();
                try {
                   
                    //getCell(index) will return indexed cell data this row data.
                    pinNumber = row.getCell(0).toString();
                    pattern = row.getCell(1).toString();
                    amount = row.getCell(2).toString();
                    amount = amount.replace(".0", "");
                   
                    System.out.println("Pin Number  ="+pinNumber);
                    System.out.println("Pattern     ="+pattern);
                    System.out.println("Amount      ="+amount);
                    System.out.println("-------------------------");
                   
                } catch (Exception ex) {
                    ex.printStackTrace();
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}