There is another alternative - even thgouh I do know that many people do not really like the technique - an ODBC driver is available that allows you to treat an Excel workbook almost as if it were a database file.
Take a look here; http://support.microsoft.com/kb/178717 and here http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.ii.doc/opt/tlsodb13.htm I am not completely certain but believe that this technique it limited to Windows only and quite possibly the binary Excel files only (.xls) but it may help you out. The other option would be to write your own wrapper classes that use POI to create and populate 'records' - instances of a class that you could define to hold the customer data. Using these, you could build an interface (in terms of an API) that would allow you to retrieve information by customer name, number, date, etc..... Yours Mark B Zachary Mitchell, BCIS wrote: > > I don't believe so, since POI doesn't support mdb files. > I imagine you'd be looking for a separate java library for that. > > > ----- Original Message ----- > From: "abhishek reddy" <[email protected]> > To: "POI Users List" <[email protected]> > Sent: Wednesday, September 30, 2009 5:30 PM > Subject: Re: retrieving data from excel sheet using apache poi > > >> thanks for the reply, >> I can able to retrieve data normally...........iterating thru one after >> the >> other row and cell >> Is there any way poi provides some jdbc kind of functionality in >> retrieving >> data? >> >> On Wed, Sep 30, 2009 at 12:20 PM, Zachary Mitchell, BCIS < >> [email protected]> wrote: >> >>> Firstly, make sure that you have access to the POI >>> javadoc web page instructions. >>> >>> Excel files have the concept of a Workbook, >>> which is the full File, and sheets within it, >>> which represent sheets. >>> >>> To open a file, you need to convert >>> a java.io.File or similar to construct the object you need. >>> >>> Look at HSSFWorkbook >>> and HSSFSheet classes. >>> >>> Also look at the "Row" classes. >>> You read rows, and cell indices across rows. >>> >>> To copy,cut or pase, you use a "CellRangeAddress" >>> object. >>> >>> If you're a confident java programmer, this is the start you will need! >>> >>> Z. >>> >>> >>> >>> ----- Original Message ----- From: "abhishek reddy" < >>> [email protected]> >>> To: <[email protected]> >>> Sent: Wednesday, September 30, 2009 3:45 PM >>> Subject: retrieving data from excel sheet using apache poi >>> >>> >>> >>> hi every one, >>>> >>>> Iam new to apache POI, i have excel spreadsheet with data.......... >>>> spread sheet contains information about several company >>>> details............. >>>> how to retrieve data specific to particular company using apache poi? >>>> Also is there any way to retrieve distinct companies from excel sheet? >>>> >>>> -- >>>> Abhishek >>>> >>>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [email protected] >>> For additional commands, e-mail: [email protected] >>> >>> >> >> >> -- >> Abhishek >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://www.nabble.com/retrieving-data-from-excel-sheet-using-apache-poi-tp25675559p25684866.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
