excel « API « Java I/O Q&A

1. java FileInputStream - differences based on how the File object is referenced: classloader/filesystem    stackoverflow.com

I'm using apache POI to extract some data from an excel file.
I need an InputStream to instantiate the POI HSSFWorkbook class
HSSFWorkbook wb = new HSSFWorkbook(inputStreamX);

I'm finding differences if ...

2. reading excel cell contents as Java InputStream    stackoverflow.com

this code reads contents of cell of excel file into a string

String theCell_00=rs.getCell(j,i).getContents();

3. Java - appending to Excel file with FileOutputStream    stackoverflow.com

This code appends to an already created Excel file:

FileOutputStream fileOut = new FileOutputStream("c:\\Decrypted.xls");

4. Write Excel data directly to OutputStream (limit memory consumption)    stackoverflow.com

I’m looking for a – simple – solution to output big excel files. Input data comes from the database and I’d like to output the Excel file directly to disk to ...

5. "Unable to recognize OLE stream" excepion while connecting to Excel    stackoverflow.com

I was trying to connect my Java program with an Excel file. I have did upto this. But it throws this excepion

Unable to recognize OLE stream

6. reading excel file + null pointer exc + inputstream is null    forums.oracle.com

after tring to solve i got the point that it could not create inputstream thats why it does not function properly ... my my quiestion is still open that why it is unable to create an input stream if i put the xls file else where instead of in the same place where java file is.... plz reply