pip install Spire.XLS

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

# 創(chuàng)建一個Workbook對象
workbook = Workbook()
# 加載Excel文件
# 請將 'sample.xlsx' 替換為你自己的Excel文件路徑
workbook.LoadFromFile("sample.xlsx")

# 獲取第一個工作表（索引從0開始）
sheet = workbook.Worksheets[0]

print(f"成功加載文件并獲取工作表：{sheet.Name}")

# 記得釋放資源
workbook.Dispose()

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

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

# 按A1表示法讀取單元格值
cell_a1_value = sheet.Range["A1"].Value
print(f"A1單元格的值: {cell_a1_value}")

# 按行、列索引讀取單元格值 (行和列索引都從1開始)
# 讀取B2單元格
cell_b2_value = sheet.Range[2, 2].Value
print(f"B2單元格的值: {cell_b2_value}")

# 讀取單元格的文本內(nèi)容（即使是數(shù)字或日期，也會返回格式化后的字符串）
cell_c3_text = sheet.Range["C3"].Text
print(f"C3單元格的文本內(nèi)容: {cell_c3_text}")

# 讀取單元格批注
if sheet.Range["A1"].Comment is not None:
    comment_text = sheet.Range["A1"].Comment.Text
    print(f"A1單元格的批注: {comment_text}")

# 讀取單元格超鏈接
if sheet.Range["A1"].HyperLink is not None:
    hyperlink_address = sheet.Range["A1"].HyperLink.Address
    print(f"A1單元格的超鏈接: {hyperlink_address}")

workbook.Dispose()

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

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

print("\n讀取區(qū)域 B2:D4 的數(shù)據(jù):")
# 循環(huán)遍歷指定區(qū)域 (例如 B2到D4)
# Range對象的Rows和Columns屬性可以幫助我們迭代
data_region = sheet.Range["B2:D4"]
for row_index in range(data_region.Row, data_region.LastRow + 1):
    row_data = []
    for col_index in range(data_region.Column, data_region.LastColumn + 1):
        cell_value = sheet.Range[row_index, col_index].Value
        row_data.append(cell_value)
    print(row_data)

workbook.Dispose()

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

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

# 假設(shè)第一行是標(biāo)題行
header = [cell.Value for cell in sheet.Rows[0].Cells]
print(f"表頭: {header}")

all_data = []
# 從第二行開始讀取數(shù)據(jù)
for row_index in range(1, sheet.LastRow): # sheet.LastRow 返回包含數(shù)據(jù)的最后一行的索引
    row_values = [sheet.Range[row_index + 1, col_index + 1].Value for col_index in range(sheet.LastColumn)]
    
    # 如果有表頭，可以將其轉(zhuǎn)換為字典列表
    if header:
        row_dict = dict(zip(header, row_values))
        all_data.append(row_dict)
    else:
        all_data.append(row_values)

print("\n讀取到的所有數(shù)據(jù) (字典列表形式):")
for item in all_data:
    print(item)

workbook.Dispose()

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

workbook = None # 初始化為None
try:
    workbook = Workbook()
    workbook.LoadFromFile("non_existent_file.xlsx") # 故意加載不存在的文件
    sheet = workbook.Worksheets[0]
    # ... 進(jìn)行其他操作 ...
except Exception as e:
    print(f"處理Excel文件時發(fā)生錯誤: {e}")
finally:
    if workbook is not None:
        workbook.Dispose() # 確保資源被釋放
        print("Workbook資源已釋放。")

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

try:
    with Workbook() as workbook: # 使用with語句自動管理資源
        workbook.LoadFromFile("sample.xlsx")
        sheet = workbook.Worksheets[0]
        print(f"工作表名稱: {sheet.Name}")
        # ... 進(jìn)行其他操作 ...
except Exception as e:
    print(f"處理Excel文件時發(fā)生錯誤: {e}")

print("Workbook資源已自動釋放。")