Skip to content

nekuwolf/Excel-to-mysql-py

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Description

This project was meant to be (quick-and-dirty) python script that convert Excel (xlsx) to MySQL ("insert into" only for now) script. The reason this was made personally for me to learn Python in general and file-interaction using python. This script was made in 2021 for college assignment, but just now published for public viewing.

How it works

Provide an xlsx file

Each sheets is treated as a individual table, and will be used as the table name

Make sure there is only ONE table on each sheet, please have a look at the provided test file

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages