Connect to excel sheet w/o saving it to server
I an excel file submitted to a jsp page that connect to the excel file and read from it like a database.
Right now I have to save the excel file to a physical location then connect to it ie:DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=e:/LocUpload.xls;DriverID=22")
I want to know if there is a way to just connect to the excel w/o saving it to the server.
Thank you,
Henry
[442 byte] By [
geiz777a] at [2007-11-27 10:33:53]

# 2
hi ,how are you
you can use jakarta POI (API)
it is an API can connect to microsoft office files including Excel files
you can download the POI from this link
poi.apache.org
Message was edited by:
Huzlenut
# 3
> hi ,how are you
> you can use jakarta POI (API)
> it is an API can connect to microsoft office files
> including Excel files
> you can download the POI from this link
> poi.apache.org
Or, better than POI, Andy Khan's JExcel:
http://andykhan.com/jexcelapi/index.html
%