470,632 Members | 1,456 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Share your developer knowledge by writing an article on Bytes.

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

# 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
4 Weeks Ago #1
0 8839

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by hstockbridge5 | last post: by
2 posts views Thread by ciaran.hudson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.