Python将Excel中的数据/文本，转化为sql

import pandas as pd
from pandas import DataFrame
import numpy as np

def xlsxfile():
	#路径请写自己的文件路径
    file = pd.read_excel("..//Desktop/data.xlsx",sheet_name='Sheet1')
    #print(file)
    #转化为dataframe
    df = pd.DataFrame(file)
    #print(df)
    str_tag = df[['Named']]
    str_value = df[['value']]
    str_datetime = '2021-09-07 09:00:00'
    #数据库需要时间戳，便带着时间戳插入
    #循环需要看自己数据量
    for i in range(0,110):

         str_SQL = "INSERT INTO EMS_02 (tag, datetime, value) values(" + "'" + str_tag.values[i][0] + "'" + ',' + "'" + str_datetime + "'" + ',' + "'" + str(str_value.values[i][0]) + "'" + ')'
         print(str_SQL)
         #这里打印完毕之后，自己复制一下也还可以

    #print(str_value.values[1])
if  __name__ == '__main__':
    res = xlsxfile()
    # print(res)