################################################################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/ )
271 Dec 30, 2022
841 Dec 21, 2022
12 Jan 01, 2023
2 Jul 18, 2022
149 Nov 28, 2022
0 Nov 09, 2022
732 Dec 31, 2022
7.8k Jan 04, 2023
1 Nov 30, 2021
3.9k Jan 08, 2023
162 Dec 19, 2022
1 Nov 07, 2022
299 Nov 20, 2022
11 May 23, 2022
11k Jan 08, 2023
1.9k Dec 25, 2022
1 Dec 25, 2021
1.2k Jan 02, 2023
7 Jun 04, 2022
4 Jul 30, 2022