Skip to content

sebukoleth/Excel2DB

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

53 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

This application lets you import an Excel workbook with multiple worksheets into 
Postgres, Oracle, MongoDB, Derby databases.

Caveats:
  - Name of the worksheet is used as tablename. This means that the worksheet name must
be a valid table name 

How to clone and build the project from the GitHub 

1. Create a folder you want to handle the project and clone the 
project from the GitHub by running 
"git clone https://github.com/palych-piter/Excel2DB.git". 
The Excel2Db subfolder should be created.

2. Run the "gradle shadowJar" gradle command. You should have the 
Gradle pre-installed.

3. All is set. The "build/libs/" subfolder should have the newest jar file
generated in the excel2db-<version>.jar format. By default the subfolder contains the property file pointing to
the Derby database as the testing implementation and test.xlsx 
as the test Excel file.

Configure 
  - the database you want to use
  - path to the Excel file 
  - names of the worksheets you want to be extracted (leave blank if all need to be processed)
  - database connection properties
in excel2db.properties

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Java 100.0%