pip install Spire.XLS.Free

from spire.xls import *
from spire.xls.common import *

# 定義要轉(zhuǎn)換的一維列表
one_dimensional_list = ["Python", "Java", "C++", "JavaScript", "Go"]

# 1. 創(chuàng)建工作簿對象
workbook = Workbook()
# 2. 獲取第一個工作表（默認創(chuàng)建）
worksheet = workbook.Worksheets[0]
# 3. 設(shè)置工作表名稱
worksheet.Name = "編程語言列表"

# 4. 遍歷列表，寫入Excel（從第1行第1列開始）
for index, value in enumerate(one_dimensional_list):
    # 行號從1開始
    row = index + 1
    # 寫入A列（第1列）
    worksheet.Range[row, 1].Text = value

# 5. 保存Excel文件（支持.xlsx/.xls/.xlsm等格式）
output_path = "一維列表轉(zhuǎn)Excel.xlsx"
workbook.SaveToFile(output_path, FileFormat.Version2016)

# 6. 釋放資源（重要，避免內(nèi)存泄漏）
workbook.Dispose()

print(f"一維列表已成功導出到：{output_path}")

from spire.xls import *
from spire.xls.common import *

# 定義二維列表（表頭+數(shù)據(jù)）
two_dimensional_list = [
    ["姓名", "年齡", "城市", "職業(yè)"],  # 表頭
    ["張三", 28, "北京", "工程師"],
    ["李四", 32, "上海", "產(chǎn)品經(jīng)理"],
    ["王五", 25, "廣州", "設(shè)計師"],
    ["趙六", 30, "深圳", "開發(fā)工程師"]
]

# 1. 創(chuàng)建工作簿
workbook = Workbook()
worksheet = workbook.Worksheets[0]
worksheet.Name = "人員信息表"

# 2. 遍歷二維列表，逐行寫入Excel
for row_index, row_data in enumerate(two_dimensional_list):
    # Excel行號從1開始
    current_row = row_index + 1
    for col_index, cell_value in enumerate(row_data):
        # Excel列號從1開始
        current_col = col_index + 1
        # 寫入單元格內(nèi)容
        worksheet.Range[current_row, current_col].Text = str(cell_value)
        
        # 3. 優(yōu)化表頭樣式（加粗、居中）
        if current_row == 1:
            worksheet.Range[current_row, current_col].Style.Font.IsBold = True
            worksheet.Range[current_row, current_col].Style.HorizontalAlignment = HorizontalAlignType.Center

# 4. 自動調(diào)整列寬（適配內(nèi)容長度）
worksheet.AllocatedRange.AutoFitColumns()

# 5. 保存文件
output_path = "二維列表轉(zhuǎn)Excel.xlsx"
workbook.SaveToFile(output_path, FileFormat.Version2016)
workbook.Dispose()

print(f"二維列表已成功導出到：{output_path}")

from spire.xls import *
from spire.xls.common import *

# 定義字典列表（模擬業(yè)務(wù)場景：從接口/數(shù)據(jù)庫獲取的用戶數(shù)據(jù)）
dict_list = [
    {"用戶ID": 1001, "姓名": "張三", "年齡": 28, "城市": "北京", "注冊時間": "2024-01-15"},
    {"用戶ID": 1002, "姓名": "李四", "年齡": 32, "城市": "上海", "注冊時間": "2024-02-20"},
    {"用戶ID": 1003, "姓名": "王五", "年齡": 25, "城市": "廣州", "注冊時間": "2024-03-10"},
    {"用戶ID": 1004, "姓名": "趙六", "年齡": 30, "城市": "深圳", "注冊時間": "2024-04-05"}
]

# 1. 創(chuàng)建工作簿和工作表
workbook = Workbook()
worksheet = workbook.Worksheets[0]
worksheet.Name = "用戶信息表（字典列表）"

# 2. 提取表頭（字典的鍵）
if not dict_list:
    print("字典列表為空，無需導出！")
    workbook.Dispose()
    exit()
# 以第一個字典的鍵作為表頭（確保所有字典鍵一致，或參考下方注意事項處理）
headers = list(dict_list[0].keys())

# 3. 寫入表頭行并設(shè)置樣式
for col_index, header in enumerate(headers):
    current_col = col_index + 1
    # 寫入表頭文本
    worksheet.Range[1, current_col].Text = header

# 4. 遍歷字典列表，寫入數(shù)據(jù)行
for row_idx, data_dict in enumerate(dict_list):
    current_row = row_idx + 2  # 表頭占第1行，數(shù)據(jù)從第2行開始
    for col_idx, header in enumerate(headers):
        current_col = col_idx + 1
        # 提取字典值（用get方法兼容鍵缺失場景，避免KeyError）
        cell_value = data_dict.get(header, "")
        # 寫入單元格（統(tǒng)一轉(zhuǎn)字符串，避免類型報錯）
        worksheet.Range[current_row, current_col].Text = str(cell_value)

# 5. 自動調(diào)整列寬（適配內(nèi)容長度）
worksheet.AllocatedRange.AutoFitColumns()

# 6. 保存Excel文件
output_path = "字典列表轉(zhuǎn)Excel.xlsx"
workbook.SaveToFile(output_path, FileFormat.Version2016)

# 7. 釋放資源
workbook.Dispose()

print(f"字典列表已成功導出到：{output_path}")

# 提取所有唯一鍵作為表頭
all_headers = set()
for d in dict_list:
    all_headers.update(d.keys())
headers = sorted(list(all_headers))  # 排序保證表頭順序固定