A tool which can batch import multiple excel files into mysql/oracle database automatically

[ryjfgjl]

# ExcelToDatabase
## Bref: A tool which can batch import multiple excel files into mysql/oracle database automatically.
## Pictures：
https://github.com/ryjfgjl/ExcelToDatabase
## Features：
Batch Automation: Import multiple excel files under directory one time

One-Click: Do not need to do anything until all excel files are imported.

High Speed: Most quickly tools like this around the world.

Inteligent: When come across some durty data or some difference between Excel and Database, tool can deal with it and go on.

Advanced Options: Rich options could be custom choose to make more fuction come true.

Free: Most important thing.

## Usage
1.Start Program

Way 1: Command: python D:\Projects\ExcelToDatabase\main.py

Way 2: Send an email to (Moderation - redacted email), you can get an exe program which can directly run on windows.

2.Input Information

Select directory with excel files; Input target database information; Choose import mode.

3.Click Start.

## Tested Environments:
Windows 7+, MySQL 5.6+/Oracle 11g+, Excel 1997+(xls,xlsx,csv)

## Options Detail:

### General：
#### Excel：
Directory: The excel files under this directory would be imported

#### MySQL/Oracle Connection:
options to connect to database
#### Mode:

Overwrite: drop table first(if exists); create table; insert data.

Append: just insert data into table(table needs exist in the database)

### Advanced：
#### CSV Encoding：
Tools can auto-detect encoding of csv files(default), and you can choose or input other value.
#### Replace To NULL：
values populated will be replaced to null.
#### Add Table Prefix：
The value populated will be added to table name before.
#### Append all data to one exists table：
Under Append mode, import all data to the table populated.
#### The Column on row：
Set which row as Column name.
#### Skip Blank Rows：
Skip Blank Rows
#### Trim SpaceS：
Trim spaces on data.
#### Skip Blank Sheets：
Ignore if no data.
#### Include Sub Directories
Find all excel files under the directory Include Sub Directories

### Others：
#### How to define table name：
file name + '_' + sheet name(if one excel has multipule sheets)
#### How to define column name：
Default is the first row
#### How to define column type：
Varchar(255) is default. If max length of column more than 255, text will be set.
#### How to deal with mysql error 1366：
Auto Correct
#### How to deal with mysql error 1118：
All column will be create as text

# Author: ryjfgjl