smartExcelToTable

This Java API helps developer to insert data from any excel sheet to a specified table without worrying about column name mismatch.

Basic Example

consider Excel table

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

How to Use

CASE 1- if you want explicit mapping also to be performed. Create a table excelfilename

Create a table exceltablemapper

use below method API

 SmartExcelToTable.kickStartSmartExcelToTable(String filename,String filepath);

example --

kickStartSmartExcelToTable("AssetData.xlsx",
				"D:/MyWs/Dashboard/exceltotable/AssetData.xlsx");