import pymysql

connection = pymysql.connect(
    host='localhost',
    user='root',
    password='123456',
    database='caiwu'
)

query = "SELECT * FROM report_品名"

import xlsxwriter

workbook = xlsxwriter.Workbook('output.xlsx')
worksheet = workbook.add_worksheet()

cursor = connection.cursor()
cursor.execute(query)

column_names = [i[0] for i in cursor.description]

import datetime

data = cursor.fetchall()

for col_index, col_name in enumerate(column_names):
    worksheet.write(0, col_index, col_name)

for row_index, row_data in enumerate(data):
    for col_index, col_data in enumerate(row_data):
        if isinstance(col_data, datetime.datetime):
            col_data = col_data.strftime("%Y-%m-%d %H:%M:%S")
        worksheet.write(row_index + 1, col_index, col_data)

cursor.close()
connection.close()
workbook.close()

import pymysql
import xlsxwriter
import datetime

# 建立數(shù)據(jù)庫(kù)連接
connection = pymysql.connect(
    host='localhost',
    user='root',
    password='123456',
    database='caiwu'
)

# 編寫(xiě)SQL查詢(xún)語(yǔ)句
query = "SELECT * FROM report_品名"

# 創(chuàng)建Excel文件對(duì)象
workbook = xlsxwriter.Workbook('output2.xlsx')

# 創(chuàng)建Excel工作表對(duì)象
worksheet = workbook.add_worksheet()

# 創(chuàng)建游標(biāo)對(duì)象
cursor = connection.cursor()

# 執(zhí)行SQL查詢(xún)
cursor.execute(query)

# 獲取查詢(xún)結(jié)果的列名
column_names = [i[0] for i in cursor.description]

# 將列名寫(xiě)入Excel文件的第一行
for col_index, col_name in enumerate(column_names):
    worksheet.write(0, col_index, col_name)

# 獲取查詢(xún)結(jié)果中的數(shù)據(jù)
data = cursor.fetchall()

# 將數(shù)據(jù)寫(xiě)入Excel文件中
for row_index, row_data in enumerate(data):
    for col_index, col_data in enumerate(row_data):
        # 判斷數(shù)據(jù)類(lèi)型是否為時(shí)間類(lèi)型
        if isinstance(col_data, datetime.datetime):
            col_data = col_data.strftime("%Y-%m-%d %H:%M:%S")  # 將時(shí)間字段轉(zhuǎn)換為字符串
        worksheet.write(row_index + 1, col_index, col_data)

# 關(guān)閉游標(biāo)對(duì)象
cursor.close()

# 關(guān)閉數(shù)據(jù)庫(kù)連接
connection.close()

# 關(guān)閉Excel文件對(duì)象
workbook.close()