I suppose to insert the excel sheet data into database using spring boot but i don't know how mainly i'm not gonna insert all the columns from the excel file ,only the columns i need to use. I don't know how to start .So can anyone help me please?
Asked
Active
Viewed 933 times
0
-
you can read excel file using Apache POI library. https://www.baeldung.com/java-microsoft-excel#1-reading-from-excel is a good link to start with POI for excel. – Demobilizer Jul 31 '20 at 11:51
-
A suggestion which may or may not work - you may be able to convert the excel file to CSV format so its easier to work with. – Rob Evans Jul 31 '20 at 12:03
-
ok thank you . I'm gonna try – user13031827 Jul 31 '20 at 13:20
1 Answers
1
Use POI library to read Data and dump it to DB through a connection. Refer to this link.
Debasis Mishra
- 41
- 5