This Java API helps developer to insert data from any excel sheet to a specified table without worrying about column name mismatch.
consider Excel table
| first | second | third |
|---|---|---|
| 1 | hii | bye |
| 2 | type | john |
| 3 | categories | miller |
| 4 | arrayofobject | simple |
| 5 | simpleobject | api |
And your traget mysql table has columns
| fir_st | secooond | TThird |
To insert data from example excel file to example table ,you need a programe with column names hard coded, but this API enables you to not worry about column names in excel or table. it smartly finds the most matched column and push data into it.
If source and dest column names are completly different , you can explicitly map the column names using a simple property file or a table
| idExcelFileName | ExcelColumn | TableColumn |
|---|---|---|
| 1 | first | SSFFRRSSTt |
CASE 1- if you want explicit mapping also to be performed. Create a table excelfilename
| id | ExcelFileName | tablename |
|---|
Create a table exceltablemapper
| id | excelColumn | tableColumn | idExcelfilename |
|---|
use below method API
SmartExcelToTable.kickStartSmartExcelToTable(String filename,String filepath);example --
kickStartSmartExcelToTable("AssetData.xlsx",
"D:/MyWs/Dashboard/exceltotable/AssetData.xlsx");