excel « Exception « Java Database Q&A





1. Reading .xls(Excel file) with JDBC (error-SQL exception)    coderanch.com

JDBC isn't the appropriate API to interact with a spreadsheet. JDBC is intented to interact with a database. Besides, the ODBC bridge driver is almost the worst JDBC driver on the world. To interact with spreadsheets, better use the appropriate API's for that. Commonly used ones are Apache POI HSSF/XSSF and Andy Khan's JExcelAPI. Information, documentation, tutorials/guides and examples are available ...