################################################################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/ )
205 Dec 16, 2022
11k Dec 29, 2022
3.4k Jan 02, 2023
4 Jul 15, 2022
3.2k Dec 30, 2022
50 Dec 23, 2022
39 Dec 03, 2022
0 Dec 31, 2021
462 Dec 24, 2022
158 Jan 07, 2023
17 Oct 10, 2021
97 Sep 05, 2022
666 Dec 30, 2022
3 Nov 15, 2021
5 Dec 01, 2021
345 Dec 25, 2022
1.2k Jan 02, 2023
1 Jan 11, 2022
27 Dec 27, 2022
127 Oct 23, 2022