import xlwt

# 創(chuàng)建一個(gè)新的Excel文件和工作表
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('Sheet1')

# 寫入數(shù)據(jù)到單元格
sheet.write(0, 0, 'Hello')
sheet.write(0, 1, 'World!')

# 保存文件
workbook.save('example.xls')

import xlwt

# 創(chuàng)建一個(gè)Workbook對(duì)象
workbook = xlwt.Workbook()
# 添加一個(gè)Sheet并設(shè)置其名稱
sheet = workbook.add_sheet('我的數(shù)據(jù)')
# 定義列表數(shù)據(jù)
data = [
    ['id', '姓名', '國(guó)家'],
    [1.0, '曹操', '魏國(guó)'],
    [2.0, '劉備', '蜀國(guó)'],
    [3.0, '孫權(quán)', '吳國(guó)'],
    [4.0, '荀彧', '魏國(guó)'],
    [5.0, '諸葛亮', '蜀國(guó)'],
    [6.0, '周瑜', '吳國(guó)'],
    [7.0, '曹仁', '魏國(guó)'],
    [8.0, '關(guān)羽', '蜀國(guó)'],
    [9.0, '呂蒙', '吳國(guó)']
]
# 寫入數(shù)據(jù)到單元格
for i, row in enumerate(data):
    for j, value in enumerate(row):
        sheet.write(i, j, value,style)
# 保存Workbook到文件
workbook.save('output.xlsx')

import xlwt
# 創(chuàng)建一個(gè)Workbook對(duì)象
workbook = xlwt.Workbook()

sheet2 = workbook.add_sheet('我的數(shù)據(jù)2')

data=[
    ['id', 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0],
    ['姓名', '曹操', '劉備', '孫權(quán)', '荀彧', '諸葛亮', '周瑜', '曹仁', '關(guān)羽', '呂蒙'],
    ['國(guó)家', '魏國(guó)', '蜀國(guó)', '吳國(guó)', '魏國(guó)', '蜀國(guó)', '吳國(guó)', '魏國(guó)', '蜀國(guó)', '吳國(guó)']]

# 寫入數(shù)據(jù)到單元格
for i, row in enumerate(data):
    for j, value in enumerate(row):
        sheet2.write(j, i, value)

# 保存Workbook到文件
workbook.save('output2.xlsx')

results = cursor.fetchall()

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

for row_index, row in enumerate(results):
    for col_index, value in enumerate(row):
        # 判斷數(shù)據(jù)類型是否為時(shí)間類型
        if isinstance(value, datetime.datetime):
            value = value.strftime("%Y-%m-%d %H:%M:%S")
        sheet.write(row_index + 1, col_index, value)

import pymysql    # 導(dǎo)入pymysql庫，用于連接MySQL數(shù)據(jù)庫
import xlwt       # 導(dǎo)入xlwt庫，用于生成Excel文件
import datetime

# 建立數(shù)據(jù)庫連接
connection = pymysql.connect(
    host='localhost',      # 數(shù)據(jù)庫主機(jī)地址
    user='root',           # 數(shù)據(jù)庫用戶名
    password='123456',     # 數(shù)據(jù)庫密碼
    database='caiwu'       # 數(shù)據(jù)庫名稱
)

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

# 執(zhí)行SQL查詢
cursor.execute("SELECT * FROM report_品名 limit 10")

# 獲取所有結(jié)果
results = cursor.fetchall()
print(results)

# 獲取列名（即各個(gè)字段名）
column_names = [i[0] for i in cursor.description]

# 創(chuàng)建Excel工作簿
workbook = xlwt.Workbook()

# 創(chuàng)建工作表（即Excel中的sheet）
sheet = workbook.add_sheet('Sheet1')

# 寫入列名到工作表中
for col_index, column_name in enumerate(column_names):
    sheet.write(0, col_index, column_name)

# 寫入數(shù)據(jù)到工作表中
for row_index, row in enumerate(results):
    for col_index, value in enumerate(row):
        # 判斷數(shù)據(jù)類型是否為時(shí)間類型
        if isinstance(value, datetime.datetime):
            value = value.strftime("%Y-%m-%d %H:%M:%S")
        sheet.write(row_index + 1, col_index, value)

# 保存Excel文件
workbook.save('output.xls')

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