Hi I searched for the above mentioned subject in this forum and I came to know about POI-HSSF for handling excel sheets from java. But I am not able to find the exact location to download the necessary jars. Could anyone tell me the exact link for that. Thanks in advance Balaji.
The easiest way I have found to read from an excel spreadsheet is with JDBC/ODBC bridge. The sun driver is included with Java 1.4.1 SDK. You use the JDBC api as with any other standard RDBMS. For instance if you wanted to read sheet 1's columns you would use a select statement like "select * from [sheet1name$]" The only issue is the [$] must be in that format for the table name. You can use the first row as the column names and access certain columns in the select statement. You then process the returned ResultSet as normal.