Creating a python package to convert /transfer excelsheet data to a mysql Database Table

Last update: Jan 07, 2022

Overview

################################################################Sourcecode:##############################################################

import pandas as pd import sys import mysql.connector as mysql from tkinter import * from tkinter import messagebox

class Convert_ExcelSheet_To_MySqlTable: def init(self,username,password,hostname,excel_file,database_name,number_of_columns,sql): self.excel_file=excel_file self.username=username self.password=password self.hostname=hostname self.sql=sql self.database_name=database_name self.number_of_columns=number_of_columns

   def Convert_to_MySqlDatabaseTable(self):
        root = Tk()
        root.withdraw()
        read=pd.read_excel(self.excel_file, engine='openpyxl')
        read_array=read.to_numpy()
        try:
            con=mysql.connect(user=self.username,password=self.password,host=self.hostname)
            messagebox.showinfo("Authentification", "You have Logged into the database successfully")
            for reading in read_array:
                  finalvalues=[]
                  count=0
                  while count

 #######################Instructions you need to followcarefully##############################
 from excelsheet_to_mysqldatabasetable.excel_converter import Convert_ExcelSheet_To_MySqlTable
 excel_file_path=open(r"C:\Users\LAMECK\Desktop\Excel Converter\documentation\db4.xlsx","rb")
 #Enter your table name and the columns you have in your mysql table .Note the columns in the excel sheet and mysql table should be in the same order. #Enter( %s ) according to the number of columns you have .
 sql=" INSERT INTO db4(serialnumber,entrynumber,volumenumber,district,year,user,hospital) VALUES(%s,%s,%s,%s,%s,%s,%s)"
 convert=Convert_ExcelSheet_To_MySqlTable(username="root",password="tangimeko7583",hostname="localhost",excel_file=excel_file_path,database_name="db4",number_of_columns=7,sql=sql) convert.Convert_to_MySqlDatabaseTable()
 found at ( https://pypi.org/project/excelsheet-to-mysqldatabasetable/2.4.0/ )

Creating a python package to convert /transfer excelsheet data to a mysql Database Table

Related tags

Overview

Owner

Odiwuor Lameck

Generate database table diagram from SQL data definition.

PyMongo - the Python driver for MongoDB

Neo4j Bolt driver for Python

An asyncio compatible Redis driver, written purely in Python. This is really just a pet-project for me.

Database connection pooler for Python

Use SQL query in a jupyter notebook!

MySQL database connector for Python (with Python 3 support)

A simple password manager I typed with python using MongoDB .

A SQL linter and auto-formatter for Humans

Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

A simple wrapper to make a flat file drop in raplacement for mongodb out of TinyDB

This repository is for active development of the Azure SDK for Python.

Apache Libcloud is a Python library which hides differences between different cloud provider APIs and allows you to manage different cloud resources through a unified and easy to use API

Example Python codes that works with MySQL and Excel files (.xlsx)

Python client for InfluxDB

DBMS Mini-project: Recruitment Management System

ClickHouse Python Driver with native interface support

An extension package of 🤗 Datasets that provides support for executing arbitrary SQL queries on HF datasets

Confluent's Kafka Python Client

Dinamopy is a python helper library for dynamodb