How to Read XLSX File in Java Using apache Poi API
Here we will implement the code to read XLSX file using apache POI API : and download required jars based on below snapshot Code : - /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package com.test.XLS; import java.io.*; import java.util.*; import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.usermodel.*; /** * * @author anand */ public class XLSReader { static final String fileName = "FriendsZone.xlsx"; FileInputStream file = null; public void readXLSFile() { try { file = new FileInputStream(new File(fileName)); XSSFWorkbook workbook = new XSSFWorkbook(file); XSSFSheet sheet = workbook.getSheetAt(0); Iterator<Row> rowIterator = sheet.iterator(); while (rowIterator.hasNext()) { Ro