pip install Spire.XLS

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

# 創(chuàng)建一個工作簿
workbook = Workbook()
# 獲取第一個工作表
sheet = workbook.Worksheets[0]

# 寫入數(shù)據(jù)
sheet.Range["A1"].Value = "姓名"
sheet.Range["B1"].Value = "年齡"
sheet.Range["C1"].Value = "出生日期"
sheet.Range["D1"].Value = "分數(shù)"

sheet.Range["A2"].Value = "張三"
sheet.Range["B2"].Value = "25"
sheet.Range["C2"].Value = "1998-05-10"
sheet.Range["D2"].Value = "85.5"

sheet.Range["A3"].Value = "李四"
sheet.Range["B3"].Value = "30"
sheet.Range["C3"].Value = "1993-11-20"
sheet.Range["D3"].Value = "92"

# 自動調(diào)整列寬
sheet.AutoFitColumn(1)
sheet.AutoFitColumn(2)
sheet.AutoFitColumn(3)
sheet.AutoFitColumn(4)

# 保存文件
workbook.SaveToFile("Sample.xlsx", ExcelVersion.Version2016)
workbook.Dispose()
print("Sample.xlsx 文件已創(chuàng)建成功！")

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

# 創(chuàng)建一個工作簿對象
workbook = Workbook()

# 加載 Excel 文件
workbook.LoadFromFile("Sample.xlsx")

# 獲取第一個工作表
sheet = workbook.Worksheets[0]
print(f"第一個工作表的名稱是: {sheet.Name}")

# 釋放資源
workbook.Dispose()

from spire.xls.common import *

workbook = Workbook()
workbook.LoadFromFile("Sample.xlsx")
sheet = workbook.Worksheets[0]

# 按行、列索引讀取單元格內(nèi)容
cell_a1_value = sheet.Range[1, 1].Value
cell_b2_value = sheet.Range[2, 2].Value

print(f"A1 單元格的值: {cell_a1_value}")
print(f"B2 單元格的值: {cell_b2_value}")

workbook.Dispose()

# 獲取已使用范圍的行數(shù)和列數(shù)
last_row = sheet.LastRow
last_column = sheet.LastColumn

# 遍歷所有行和列
for row inrange(1, last_row + 1):
    row_data = []
for col inrange(1, last_column + 1):
        cell = sheet.Range[row, col]
        value = cell.Value
if cell.ValueType == CellValueType.IsDateTime:
            value = datetime.strptime(value, "%Y-%m-%d")
        row_data.append(value)
print(row_data)

# 示例：計算分數(shù)列的總和
total_score = 0
for row inrange(2, last_row + 1):
    score_cell = sheet.Range[row, 4]
if score_cell.ValueType == CellValueType.IsNumber:
        total_score += float(score_cell.Value)
print(f"\n總分數(shù): {total_score}")

workbook.Dispose()

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

workbook = Workbook()
workbook.LoadFromFile("Sample.xlsx")
sheet = workbook.Worksheets[0]

# 讀取 A1:C3 區(qū)域的數(shù)據(jù)
range_data = sheet.Range["A1:C3"]

print("--- 讀取 A1:C3 區(qū)域的數(shù)據(jù) ---")
for row_index inrange(range_data.Row, range_data.LastRow + 1):
    row_values = []
for col_index inrange(range_data.Column, range_data.LastColumn + 1):
        cell_value = sheet.Range[row_index, col_index].Value
        row_values.append(cell_value)
print(row_values)

workbook.Dispose()

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

# 創(chuàng)建一個包含公式的 Excel 文件
workbook_formula = Workbook()
sheet_formula = workbook_formula.Worksheets[0]
sheet_formula.Range["A1"].Value = "10"
sheet_formula.Range["A2"].Value = "20"
sheet_formula.Range["A3"].Formula = "=SUM(A1:A2)"

workbook_formula.SaveToFile("FormulaSample.xlsx", ExcelVersion.Version2016)
workbook_formula.Dispose()

# 讀取包含公式的 Excel 文件
workbook = Workbook()
workbook.LoadFromFile("FormulaSample.xlsx")
sheet = workbook.Worksheets[0]

# 讀取公式單元格
formula_cell = sheet.Range["A3"]
print(f"A3 單元格的公式: {formula_cell.Formula}")
print(f"A3 單元格的計算結(jié)果: {formula_cell.Value}")

workbook.Dispose()