how to read *.xls and *.xlsx file and need insert data in DB

,
1

Hi All,

i need read excel spread sheet files(*.xls and *.xlsx) and insert data in to DB table.

Regards,
Anil Kumar Ellendula

2

Apache POI (http://poi.apache.org/) contains APIs which is capable of reading excel files in both XLS format an Office OpenXML (XLSX). You could develop Java service that uses this API to extract required data. Inserting into DB is achieved using the JDBC Adapter functionality assuming you are licensed for that.

1 Like