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

A database migrations tool for SQLAlchemy.

Official Python low-level client for Elasticsearch

A Python wheel containing PostgreSQL

Database connection pooler for Python

MySQL Operator for Kubernetes

MySQL database connector for Python (with Python 3 support)

Databank is an easy-to-use Python library for making raw SQL queries in a multi-threaded environment.

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

A supercharged SQLite library for Python

Motor - the async Python driver for MongoDB and Tornado or asyncio

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

New generation PostgreSQL database adapter for the Python programming language

Redis Python Client - The Python interface to the Redis key-value store.

Dinamopy is a python helper library for dynamodb

Use SQL query in a jupyter notebook!

A pandas-like deferred expression system, with first-class SQL support

Async ORM based on PyPika

SAP HANA Connector in pure Python

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

Monty, Mongo tinified. MongoDB implemented in Python !