plabin/Xl_to_SQL
Watch
1
0
Fork
You've already forked Xl_to_SQL
 0
mirror of https://github.com/F1r3f0x/Xl_to_SQL.git synced 2026-08-14 01:16:43 -04:00
Code Issues Projects Releases Packages Wiki Activity
Scans a formated excel file and creates an sql script to fill a database.
27 commits 1 branch 0 tags 123 KiB
  • Python 100%
Find a file
Exact
Repository files (latest commit first)
Filename Latest commit message Latest commit date
F1r3f0x 955bd8d077 update .gitignore
2026-06-16 10:13:58 -04:00
.gitignore update .gitignore 2026-06-16 10:13:58 -04:00
example_book.xlsx Fixed unesacaped chars, updated example, added requirements.txt and fixed readme 2019-03-17 18:43:51 -03:00
example_output.sql Better example book, fixed ouput argument and added and output example. 2017-06-19 14:48:50 -04:00
license.txt Update license.txt 2019-03-17 18:55:25 -03:00
readme.md Fixed unesacaped chars, updated example, added requirements.txt and fixed readme 2019-03-17 18:43:51 -03:00
requirements.txt Fixed unesacaped chars, updated example, added requirements.txt and fixed readme 2019-03-17 18:43:51 -03:00
Xl_to_SQL.py Fixed unesacaped chars, updated example, added requirements.txt and fixed readme 2019-03-17 18:43:51 -03:00

readme.md

Xl to SQL

Scans a formatted excel file and creates an sql script to fill a database.

Dependencies:

  • Python 3.6
  • Openpyxl 2.4.5

Usage:

Xl_to_SQL.py [-h] [-o O] input_file

  • positional arguments:

    • input_file Input Excel file to process

  • optional arguments:

    • -h, --help show this help message and exit
    • -o O Output SQL script

TODO:

  • Locate tables in a single page
  • Multiple file processing

Patricio Labin Correa - 09/17

GPL 3 License