################################################################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/ )
629 Nov 21, 2022
1 Feb 08, 2022
428 Dec 29, 2022
33 Dec 08, 2022
0 Nov 09, 2022
4 Oct 21, 2022
0 Dec 31, 2021
2.6k Dec 27, 2022
550 Jan 01, 2023
6 Oct 31, 2022
1.5k Dec 30, 2022
207 Dec 30, 2022
1 Nov 07, 2022
253 Dec 31, 2022
3.2k Dec 30, 2022
1 Nov 09, 2021
7.2k Jan 09, 2023
3.7k Jan 08, 2023
666 Dec 30, 2022