I am currently working on excel service which is responsible to dump data from excel file to database (POSTGRESQL) and I’ve found too many ways to achieve that but it still lacks efficiency.

Currently I’m using APACHE-POI Library with stream reader (https://github.com/pjfanning/excel-streaming-reader) one faster way i’ve found to dump data from excel to database is that, I convert excel file to csv and then create temporary table with same structure as excel file and then I use Copy Command SQL with ” FROM STDIN WITH (FORMAT CSV, HEADER FALSE)” this statement, it is the fastest way I’ve found till now but i don’t think it is still most-efficient way.

For every other business logic and validation, i’ve to write crafted-query for that. is there any other efficient way to achieve that?

Tried searching for that but found none.