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

Python DBAPI simplified

A Telegram Bot to manage Redis Database.

ClickHouse Python Driver with native interface support

Asynchronous interface for peewee ORM powered by asyncio

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

AWS SDK for Python

Estoult - a Python toolkit for data mapping with an integrated query builder for SQL databases

Script em python para carregar os arquivos de cnpj dos dados públicos da Receita Federal em MYSQL.

dask-sql is a distributed SQL query engine in python using Dask

GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.

A Python library for Cloudant and CouchDB

Asynchronous, fast, pythonic DynamoDB Client

This is a repository for a task assigned to me by Bilateral solutions!

Redis Python Client

MySQL database connector for Python (with Python 3 support)

A simple Python tool to transfer data from MySQL to SQLite 3.

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

db.py is an easier way to interact with your databases

A simple password manager I typed with python using MongoDB .

A Python DB-API and SQLAlchemy dialect to Google Spreasheets