Posts

Showing posts from January, 2017

How to Read XLSX File in Java Using apache Poi API

Image
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 ...