Skip to content

DocMorg/testworkhse

Repository files navigation

testworkhse

Codacy Badge

Excel to PostgreSQL transmitter written on Python 3.7

for help type in command line:

$ python project.py -h

This is the test work, which purpose is to merge data from Microsoft Excel (.xlsx format) data files to PostgreSQL database. It supports creating table with excel file on input {-c}, updating it {-upd} and adding indexes {-ai}. If there is an type intersection in one row during updating or creating, the whole row will be converted to string format. Names of the rows should be on the first line of the file.

To run the program type in command line:

$ python project.py excel.xlsx [-args]

where excel.xlsx - is the MS Excel file entry and -args - argument you need.

In the 'test.py' file are the tests made for this program.

About

Excel to PostgreSQL transmitter written on Python 3.7

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published