Java Read/Write Excel - Error : The constructor XSSFWorkbook(FileInputStream) is undefined

Question

I am trying to read data from an excel file, i am using the following code :

File src = new File("T:\\SeleniuminputFiles\\input.xlsx");
FileInputStream fis = new FileInputStream(src);
XSSFWorkbook wb = new XSSFWorkbook(fis);
XSSFSheet sheet1 = wb.getSheetAt(0);

but i am getting the compilation error as The constructor XSSFWorkbook(FileInputStream) is undefined.

I have downloaded External Jar files from The latest stable release Apache POI 3.16 http://poi.apache.org/download.html#POI-3.16

Your help would be highly appreciated.

change FileInputStream fis=... to InputStream fis=... look it up here — XtremeBaumer
File src = new File("T:\\SeleniuminputFiles\\input.xlsx"); InputStream fis = new FileInputStream(src); works perfectly fine — XtremeBaumer
Hi the issue is with line 14 as per screenshot.. The problem is with XSSFWorkbook wb = new XSSFWorkbook(fis); — Sushant Tavrawala
@XtremeBaumer FileInputStream is an InputStream, so you should be able to pass it as an InputStream. — DodgyCodeException

Rahul Karankal Rahul Karankal · Accepted Answer · 2017-09-07T10:50:13

Try using FileInputStream :

public void ReadExcel()
    {
       String excelFilePath = "D://Selenium Training//ExcelSearch//Configurations.xlsx";

       FileInputStream inputStream = new FileInputStream(new File(excelFilePath));

       Workbook workbook = new XSSFWorkbook(inputStream);

       Sheet firstSheet = workbook.getSheetAt(0);
    }

Java Read/Write Excel - Error : The constructor XSSFWorkbook(FileInputStream) is undefined

4 Answers