ExcelToSQL源码

# ExcelToSQL ``` Extract data from .XLSX format Excel file and convert it into standard SQL and sink into specified database. The parameter is depend on your .xml configuration. And data insert operation is done by JDBC. 1. Only support read from .xlsx format excel. 2. Now you can only insert data into PostgreSQL. ``` # Developing ExcelToSQL ``` Java: JDK1.8 Maven: 3.6.3 encoding ：UTF-8 ``` # Dependency ``` dom4j 2.1.3 poi 4.1.0 poi-ooxml 4.1.0 postgresql 42.2.18 logback-core 1.2.3 logback-classic 1.2.3 lombok 1.18.16 commons-net 3.7.2 ``` # How to Build： ``` In Idea: Build ==> Build Artifacts.. ==> Build The generated file is in ./out/artifacts/ ``` # Operation instruction ``` 1.Build it(see How to Build),and you will see a generated jar file ExcelToDB2.jar. 2.copy 3 xml module file from resources/module/ to your generated jar file's resources directory. 3.modify 3 xml module file，and open cmd or powershell at the dictory of the jar file. 4.run the command：java -jar ExcelToDB2.jar </br> 5.a logs dictory will be generated,and it record the bugs or running info. When you encounter a BUG at production , you can view the logs in the 'logs' folder to locate the problem. ``` # Version v1.0.4 Now, you can read xlsx files of any size!</br> # Support Don’t hesitate to ask!</br> Contact the author if you need any help. Email: airdest@163.com </br> Open an issue if you found a bug in ExcelToSQL.</br> # v1.0.5 Features is under development ``` 1. Supprot read file from ftp/sftp. 2. Add support insert into MySQL.(Now only PostgreSQL) 3. split the hole system into two independent module, one is for SQL generate,another is for insert data into all kinds of database, so it will support as many database as it can. ```