WorkbookFactory.create(inputStream)

Question

Here is my piece of code for reading file in xlsx and xls format

File customerTemplateFileObj = new File(customerTemplateFullPath);
InputStream inputStream = new FileInputStream(customerTemplateFileObj);

Workbook myWorkBook = null;
try {

    ***myWorkBook = WorkbookFactory.create(inputStream);***
} 
catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
}

int totalSheets = myWorkBook.getNumberOfSheets();

My code is working fine for xls format but for xlsx its stop at

myWorkBook = WorkbookFactory.create(inputStream);

without any Exception.

Answer 1

for reading xlsx file extion in java use XSSFWorkbook class from poi jar

package com.ssaurel.samples.excel;

import java.io.File; 

import java.io.FileInputStream;

import java.io.IOException;

import java.util.Iterator;


import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;


public class ReadExcel {

  public static void main(String[] args) throws IOException {
    File excelFile = new File("contacts.xlsx");
    FileInputStream fis = new FileInputStream(excelFile);

    // we create an XSSF Workbook object for our XLSX Excel File
    XSSFWorkbook workbook = new XSSFWorkbook(fis);

    // ...

  }

}