excel转csv xlsx转csv

[python]代码库

import openpyxl
import csv

# 打开 Excel 文件
workbook = openpyxl.load_workbook('example.xlsx')

# 选择工作表
sheet = workbook['Sheet1']

# 导出数据到 CSV 文件
with open('example.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    for row in sheet.iter_rows():
        writer.writerow([cell.value for cell in row])