Python -多个XLSX/XLSM到CSV

import pandas as pd

# 读取XLSX/XLSM文件
df = pd.read_excel('file.xlsx')

# 将数据保存为CSV文件
df.to_csv('file.csv', index=False)

from openpyxl import load_workbook
import csv

# 读取XLSX/XLSM文件
workbook = load_workbook('file.xlsx')
sheet = workbook.active

# 将数据保存为CSV文件
with open('file.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    for row in sheet.iter_rows():
        writer.writerow([cell.value for cell in row])

import xlrd
import csv

# 读取XLSX/XLSM文件
workbook = xlrd.open_workbook('file.xlsx')
sheet = workbook.sheet_by_index(0)

# 将数据保存为CSV文件
with open('file.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    for row in range(sheet.nrows):
        writer.writerow(sheet.row_values(row))