Re: Reading documents(excel) from Database

[Chris Cheshire]

An InputStream is just a stream that you can read from. Don't think of 
it in terms of a filesystem, that is just one small use of it. All POI 
is concerned about is being able to read from the stream. It could come 
from a local file, it could come from data read over a socket.

If you store the spreadsheet as a blob in the database, you can then 
retrieve it via a normal sql query, and grab an inputstream from the 
java blob and use it in the POI libraries.

Of course this ultimately depends on whether the database you are using 
has blob functionality implemented, and their java drivers can handle it.

HTH

Chris

Hal�sz B�lint wrote:
Hi,
 
I am newbie in POI.
My primary question is :
- Is it possible to load document(excel) from database? And if yes how?
 
I am asking this because from the doc and API it is not quite clear the
 <http://jakarta.apache.org/poi/apidocs/org/apache/poi/poifs/filesystem/POIFSFileSystem.html#POIFSFileSystem(java.io.InputStream)> POIFSFileSystem(java.io.InputStream stream) 
can handle inputreams coming from source other than filesystem.
 
Thanx for the help in advance,
Balint



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]