Unable to instantiate an object of XSSFWorkbook in Java servlet

Question

I'm trying to work with XSSFWorkbook in my web application. I ran a sample application with XSSFWorkbook as a plain Java program (with public static void main(String args[])) - it runs fine - an excel sheet is generated.

However, when I run the same piece of code in my java based web application - an instance of XSSFWorkbook is not instantiated. No Exception is thrown either!

Please help!

score 0 · Answer 1 · answered Nov 19 '14 at 12:57

0

the below code works perfectly fine for me

public void trackerUploadListener(FileUploadEvent event) throws Exception {
    UploadedFile tracker = event.getUploadedFile();
    XSSFWorkbook wb = null;
    InputStream stream = tracker.getInputStream();
    wb = new XSSFWorkbook(stream);  
}
Here, the listener is called from my xhtml page.

answered Nov 19 '14 at 12:57

Yusuf Kapasi

577
2
9

Hi yusuf, I had done in the same way you had done. Kindly specify the jars you had used and i am using maven project. – Yogiraj Havinal Nov 22 '14 at 06:30
I have used apache-poi API. – Yusuf Kapasi Nov 22 '14 at 10:12
hi, i am using the same jar but still i am getting that error – Yogiraj Havinal Nov 22 '14 at 15:55

Unable to instantiate an object of XSSFWorkbook in Java servlet

1 Answers1