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()) {

                Row row = rowIterator.next();

                Iterator<Cell> cellIterator = row.cellIterator();

                while (cellIterator.hasNext()) {

                    Cell cell = cellIterator.next();

                    switch (cell.getCellType()) {
                        case Cell.CELL_TYPE_NUMERIC:

                            System.out.print(cell.getNumericCellValue() + "\t");

                            break;

                        case Cell.CELL_TYPE_STRING:

                            System.out.print(cell.getStringCellValue() + "\t");

                            break;
                    }
                }

                System.out.println("");
            }

            file.close();

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            if (file != null) {

                try {

                    file.close();

                } catch (IOException ex) {

                    //Logger.getLogger(XLSReader.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        }
    }

    public static void main(String[] args){
     
            new XLSReader().readXLSFile();
         
     
    }
}



For any Doubt please comment it . Thanks 

Comments

Post a Comment

Popular posts from this blog

Converting JSONArray into CSV file in java

-
package com.loginController; import java.io.File; import org.apache.commons.io.FileUtils; import org.json.CDL; import org.json.JSONArray; import org.json.JSONObject; /**  *  * @author anand  *  */ public class ConvertArray {     public static void main(String myHelpers[]){         String jsonArrayString = "{\"fileName\": [{\"name\": \"Anand\",\"last\": \"Dwivedi\",\"place\": \"Bangalore\"}]}";         JSONObject output;         try {             output = new JSONObject(jsonArrayString);             JSONArray docs = output.getJSONArray("fileName");             File file=new File("JSONSEPERATOR.csv");             String csv = CDL.toString(docs);             FileUtils.writeStringToFile(file, csv);         ...
Read more

Java Design pattern

-
 Singleton Design pattern :-  it's Creational Design Pattern as we need to have only one instance of our class for Ex:- Logger,DBConnector. SingleObject class have its constructor as private and have a static instance of itself. Code:-  public class Singleton { private static Singleton object; private Singleton() { } public static synchronized Singleton getInstance() { if (object == null) object = new Singleton(); return object; } } Eager Initialization :-  public class Singleton { private static Singleton object = new Singleton(); private Singleton() { } public static Singleton getInstance() { return object; } } Double checked Locking :-  public class Singleton { private static volatile Singleton obj = null; private Singleton() { } public static Singleton getInstance() { if (obj == null) { synchronized (Singleton.class) { if (obj == null) obj = new Singleton(); } } ...
Read more

Map class field to map

-
 import java.lang.reflect.Field; import java.util.HashMap; import java.util.Map; public class AutogeneratedClassMapper {     public static Map<String, Object> mapFieldsToMap(Object obj) throws IllegalAccessException {         Map<String, Object> fieldMap = new HashMap<>();         Class<?> clazz = obj.getClass();         Field[] fields = clazz.getDeclaredFields();         for (Field field : fields) {             field.setAccessible(true);             Object value = field.get(obj);             fieldMap.put(field.getName(), value);         }         return fieldMap;     }     // Example usage     public static void main(String[] args) throws IllegalAccessException {         AutogeneratedClass au...
Read more