Error while reading Excel file.

[Slaxmi Raj]

Hai , i am trying to read excel file ,but getting compilation error when passing file path.please any one help how to reduce the error.
Error:

Exception in thread "main" java.lang.Error: Unresolved compilation problem:
The constructor XSSFWorkbook(FileInputStream) is undefined

import org.apache.poi.openxml4j.opc.Package;
import org.apache.poi.xssf.usermodel.XSSFWorkbook; 
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import java.util.Iterator;
import java.io.*;

public class ReadItemMaster_Database {

	
	public static void main(String[] args) {
		ReadItemMaster_Database rid=new  ReadItemMaster_Database();
		try{
			rid.ReadSheet();
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		
		

	}
	 public void ReadSheet() throws Exception
	    {
	        String filename = "C:\\New Folder\\test1.xlsx";
	        FileInputStream fis = null;
	        try {
	            fis = new FileInputStream(filename);
	            
	            XSSFWorkbook workbook;
	            workbook= new XSSFWorkbook(fis);
	            XSSFSheet sheet = workbook.getSheetAt(0);
	            Iterator rows = sheet.rowIterator();
	            int number=sheet.getLastRowNum();
	            System.out.println(" number of rows"+ number);
	            while (rows.hasNext())
	            {
	 
	                XSSFRow row = ((XSSFRow) rows.next());
	                Iterator cells = row.cellIterator();
	                while(cells.hasNext())
	                {
	                    XSSFCell cell = (XSSFCell) cells.next();
	                    String Value=cell.getStringCellValue();
	                    System.out.println(Value);
	                }
	             }
	        } catch (IOException e) {
	            e.printStackTrace();
	        } finally {
	            if (fis != null) {
	                fis.close();
	            }
	        }
	    }
}

[John Jai]

The error indicates that there is no constructor in the class XSSFWorkbook class that takes a FileInputStream argument. If you are using this XSSFWorkbook class, then from its API you can see a constructor that takes a java.io.InputStream and hence you should receive no error.

The reason might be you are using an older version of the jar file which contains XSSFWorkbook class.

[Slaxmi Raj]

Thank you for your reply..
please tell me what are the jar files i have to add.
thank you.

[John Jai]

I don't know about Apache POI jars. Please check in the internet or download from Apache POI website.

Moving thread to Open Source forum.