################################################################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/ )
2 Oct 05, 2022
3.3k Dec 31, 2022
7 Aug 21, 2022
1.5k Jan 03, 2023
17 Oct 10, 2021
762 Dec 30, 2022
550 Jan 01, 2023
1.2k Jan 03, 2023
582 Dec 28, 2022
428 Dec 29, 2022
732 Dec 31, 2022
554 Dec 04, 2022
180 Jan 01, 2023
1.5k Dec 30, 2022
1.9k Jan 04, 2023
522 Jan 01, 2023
1 Nov 30, 2021
345 Dec 28, 2022
127 Oct 23, 2022
0 Jul 06, 2022