pip install Spire.XLS

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

# 創(chuàng)建一個(gè)Excel工作簿對(duì)象
workbook = Workbook()
# 獲取第一個(gè)工作表
sheet = workbook.Worksheets[0]

# 向單元格A1寫入數(shù)據(jù)
sheet.Range["A1"].Value = "Hello, Spire.XLS!"

# 保存文件
workbook.SaveToFile("HelloWorld.xlsx", ExcelVersion.Version2016)
workbook.Dispose()

print("Excel文件 'HelloWorld.xlsx' 已成功創(chuàng)建。")

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

workbook = Workbook()
sheet = workbook.Worksheets[0]

# 一維列表數(shù)據(jù)
data_list = ["Apple", "Banana", "Cherry", "Date", "Elderberry"]

# 將列表數(shù)據(jù)寫入A列，從A1單元格開始
# sheet.Range["A1"].LoadFromArrays([data_list]) 這種方式會(huì)把整個(gè)list寫入A1，不是我們想要的
# 我們可以遍歷列表，逐個(gè)寫入單元格
for i, item in enumerate(data_list):
    sheet.Range[f"A{i+1}"].Value = item

# 或者更簡(jiǎn)潔的方式，使用 LoadFromDataTable 或 LoadFromArray
# 由于List本身不是DataTable，我們可以巧妙地將其轉(zhuǎn)換為二維列表進(jìn)行加載
# sheet.Range["B1"].LoadFromArrays([[item] for item in data_list]) # 寫入B列
# sheet.Range["C1"].LoadFromArrays([data_list]) # 寫入C行

# 示例：寫入到B列
sheet.Range["B1"].LoadFromArrays([[item] for item in data_list])

# 示例：寫入到C行
sheet.Range["C1"].LoadFromArrays([data_list])


workbook.SaveToFile("OneDListToExcel.xlsx", ExcelVersion.Version2016)
workbook.Dispose()

print("一維List數(shù)據(jù)已寫入 'OneDListToExcel.xlsx'。")

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

workbook = Workbook()
sheet = workbook.Worksheets[0]

# 二維列表數(shù)據(jù)（模擬表格數(shù)據(jù)）
data_matrix = [
    ["ID", "Name", "Age", "City"],
    [101, "Alice", 30, "New York"],
    [102, "Bob", 24, "London"],
    [103, "Charlie", 35, "Paris"],
    [104, "David", 29, "Tokyo"]
]

# 將二維列表數(shù)據(jù)寫入Excel，從A1單元格開始
# LoadFromArrays方法非常適合這種場(chǎng)景
sheet.Range["A1"].LoadFromArrays(data_matrix)

# 自動(dòng)調(diào)整列寬以適應(yīng)內(nèi)容
sheet.AutoFitColumn(1)
sheet.AutoFitColumn(2)
sheet.AutoFitColumn(3)
sheet.AutoFitColumn(4)


workbook.SaveToFile("TwoDListToExcel.xlsx", ExcelVersion.Version2016)
workbook.Dispose()

print("二維List數(shù)據(jù)已寫入 'TwoDListToExcel.xlsx'。")

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

workbook = Workbook()
sheet = workbook.Worksheets[0]

# 標(biāo)題行
headers = ["Product", "Quantity", "Price", "Total"]

# 數(shù)據(jù)行
product_data = [
    ["Laptop", 5, 1200.00, 6000.00],
    ["Mouse", 20, 25.50, 510.00],
    ["Keyboard", 10, 75.00, 750.00],
    ["Monitor", 3, 300.00, 900.00]
]

# 寫入標(biāo)題行
sheet.Range["A1"].LoadFromArrays([headers])

# 設(shè)置標(biāo)題行樣式
header_range = sheet.Range["A1:D1"]
header_range.Style.KnownColor = ExcelColors.LightBlue
header_range.Style.Font.IsBold = True
header_range.HorizontalAlignment = HorizontalAlignType.Center
header_range.VerticalAlignment = VerticalAlignType.Center

# 寫入數(shù)據(jù)行，從第二行開始
sheet.Range["A2"].LoadFromArrays(product_data)

# 自動(dòng)調(diào)整列寬
sheet.AutoFitColumns()

workbook.SaveToFile("ListWithHeaderToExcel.xlsx", ExcelVersion.Version2016)
workbook.Dispose()

print("帶標(biāo)題的List數(shù)據(jù)已寫入 'ListWithHeaderToExcel.xlsx'。")

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

workbook = Workbook()
sheet = workbook.Worksheets[0]

headers = ["Item", "Count", "Value"]
data = [
    ["A", 10, 100.50],
    ["B", 20, 200.75],
    ["C", 30, 300.25]
]

# 寫入數(shù)據(jù)
sheet.Range["A1"].LoadFromArrays([headers] + data)

# 設(shè)置第一行字體為紅色
sheet.Range["A1:C1"].Style.Font.Color = ExcelColors.Red

# 設(shè)置第二行背景色為淺綠
sheet.Range["A2:C2"].Style.KnownColor = ExcelColors.LightGreen

# 設(shè)置第三列為貨幣格式
sheet.Range["C2:C4"].NumberFormat = "$#,##0.00"

# 設(shè)置列寬
sheet.Columns[0].ColumnWidth = 15
sheet.Columns[1].ColumnWidth = 10
sheet.Columns[2].ColumnWidth = 15

# 保存為不同格式（可選）
# workbook.SaveToFile("FormattedData.xls", ExcelVersion.Version97to2003) # 保存為舊版.xls
workbook.SaveToFile("FormattedData.xlsx", ExcelVersion.Version2016) # 保存為新版.xlsx
workbook.Dispose()

print("格式化后的數(shù)據(jù)已寫入 'FormattedData.xlsx'。")