pip install Spire.Xls.Free

from spire.xls import *

def read_csv_file(file_path):
    # 創(chuàng)建Workbook對(duì)象
    workbook = Workbook()
    # 加載CSV文件
    workbook.LoadFromFile(file_path, ",", 1, 1)
    
    # 獲取第一個(gè)工作表（CSV文件加載后默認(rèn)生成一個(gè)工作表）
    worksheet = workbook.Worksheets[0]
    
    # 獲取工作表的行數(shù)和列數(shù)
    row_count = worksheet.LastRow
    col_count = worksheet.LastColumn
    
    # 遍歷所有單元格并打印數(shù)據(jù)
    print("CSV文件內(nèi)容：")
    for row in range(1, row_count + 1):
        row_data = []
        for col in range(1, col_count + 1):
            cell_value = worksheet.Range[row, col].Text
            row_data.append(cell_value)
        print("\t".join(row_data))
    
    # 釋放資源
    workbook.Dispose()

# 調(diào)用函數(shù)讀取CSV文件
if __name__ == "__main__":
    csv_file_path = "sales_data.csv"  # 替換為你的CSV文件路徑
    read_csv_file(csv_file_path)

from spire.xls import *

def read_csv_with_filter(file_path):
    workbook = Workbook()
    workbook.LoadFromFile(file_path, ",", 1, 1)
    worksheet = workbook.Worksheets[0]
    
    row_count = worksheet.LastRow
    col_count = worksheet.LastColumn
    
    # 假設(shè)第3列是銷售額（數(shù)值型），篩選銷售額>1000的行
    print("銷售額>1000的記錄：")
    # 跳過表頭（第一行）
    for row in range(2, row_count + 1):
        # 獲取銷售額單元格的值并轉(zhuǎn)換為浮點(diǎn)數(shù)
        sales_value = float(worksheet.Range[row, 3].Text)
        if sales_value > 1000:
            row_data = []
            for col in range(1, col_count + 1):
                row_data.append(worksheet.Range[row, col].Text)
            print("\t".join(row_data))
    
    workbook.Dispose()

if __name__ == "__main__":
    read_csv_with_filter("sales_data.csv")

from spire.xls import *

def write_csv_file(file_path):
    # 創(chuàng)建Workbook對(duì)象
    workbook = Workbook()
    # 移除默認(rèn)的工作表，創(chuàng)建新工作表
    workbook.Worksheets.Clear()
    worksheet = workbook.Worksheets.Add("CSV_Data")
    
    # 定義表頭和數(shù)據(jù)
    header = ["姓名", "部門", "薪資", "入職時(shí)間"]
    data = [
        ["張三", "銷售部", "15000", "2023-01-10"],
        ["李四", "技術(shù)部", "12000", "2023-03-15"],
        ["王五", "市場部", "8000", "2022-11-20"]
    ]
    
    # 寫入表頭
    for col in range(len(header)):
        worksheet.Range[1, col + 1].Text = header[col]
    
    # 寫入數(shù)據(jù)
    for row in range(len(data)):
        for col in range(len(data[row])):
            worksheet.Range[row + 2, col + 1].Text = data[row][col]
    
    # 保存為CSV文件（指定編碼為UTF-8，避免中文亂碼）
    worksheet.SaveToFile(file_path, ",", Encoding.get_UTF8())
    
    # 釋放資源
    workbook.Dispose()
    print(f"CSV文件已成功寫入：{file_path}")

if __name__ == "__main__":
    write_csv_file("employee_data.csv")

from spire.xls import *

def append_to_csv(file_path, new_data):
    # 加載已有CSV文件
    workbook = Workbook()
    workbook.LoadFromFile(file_path, ",", 1, 1)
    worksheet = workbook.Worksheets[0]
    
    # 獲取已有數(shù)據(jù)的最后一行
    last_row = worksheet.LastRow
    
    # 追加新數(shù)據(jù)
    for row in range(len(new_data)):
        for col in range(len(new_data[row])):
            worksheet.Range[last_row + row + 1, col + 1].Text = new_data[row][col]
    
    # 保存到新CSV文件
    worksheet.SaveToFile("new_employee_data.csv", ",", Encoding.get_UTF8())
    workbook.Dispose()

if __name__ == "__main__":
    # 要追加的新數(shù)據(jù)
    new_data = [
        ["趙六", "財(cái)務(wù)部", "9000", "2023-05-01"],
        ["孫七", "行政部", "7500", "2023-02-28"]
    ]
    append_to_csv("employee_data.csv", new_data)