jeusgao / excel_to_oracle Public

Notifications You must be signed in to change notification settings
Fork 1
Star 7

Insert excel spreadsheet into oracle database, convert excel to sql, excel报表映射数据库，excel报表导入数据库(oracle)

7 stars 1 fork Branches Tags Activity

Notifications

Name	Name	Last commit message	Last commit date
Latest commit History 20 Commits
test	test
.gitignore	.gitignore
README.md	README.md
__init__.py	__init__.py
config.py	config.py
config_oracle.yml	config_oracle.yml
insert_to_oracle.py	insert_to_oracle.py
requirements.txt	requirements.txt
tools.py	tools.py

Repository files navigation

excel_to_oracle

各类业务应用软件输出的excel报表，解析配置映射库表，输出SQL或导入数据库，实现业务报表与数据库的前后端连接。

定义excel报表结构解析
插入oracle
输出SQL

-- 小工具 -- python3.6.X

Reference:

https://github.com/cwade/pandas_oracle

About

Insert excel spreadsheet into oracle database, convert excel to sql, excel报表映射数据库，excel报表导入数据库(oracle)

python36 excel-to-sql

Report repository

Releases

No releases published

Packages

No packages published

Languages

Python 100.0%