求一段代码打开某个csv文件另存为.xlsm格式

PP不吃香菜

求一段 PYTHON 代码打开 D:\panjiang\1.csv文件  .  另存为1.xlsm . 保存。(不退出。文件保持打开。)

谢谢大家。

PP不吃香菜

import pandas as pd
from openpyxl import load_workbook

# 读取 CSV 文件
#df = pd.read_csv('D:\\panjiang\\1.csv')
df = pd.read_csv('D:\\panjiang\\1.csv', encoding='GBK')

# 将数据写入 Excel 文件（.xlsm 格式需要手动启用宏的工作簿）
with pd.ExcelWriter('D:\\panjiang\\1.xlsm', engine='openpyxl') as writer:
    df.to_excel(writer, index=False)


不知道哪里错了。新建1成功了 内容写不进去。

xjl565135022

from openpyxl import Workbook
import csv
file_path= '/Users/liaogege/Desktop/test.csv'
wb = Workbook()
ws = wb.active
with open(file_path, 'r') as csvfile:
    reader = csv.reader(csvfile)
    for row_index,rows in enumerate(reader):
        for index,value in enumerate(rows):
            ws.cell(row_index+1,index+1).value=value
wb.save('/Users/liaogege/Desktop/'+ 'csv.xlsm')

我没用过Pandas，只能用cvs跟openpyxl

xjl565135022

PP不吃香菜 发表于 2024-8-30 13:44
import pandas as pd
from openpyxl import load_workbook

from openpyxl import Workbook
import csv
file_path= '/Users/liaogege/Desktop/test.csv'
wb = Workbook()
ws = wb.active
with open(file_path, 'r') as csvfile:
    reader = csv.reader(csvfile)
    for row_index,rows in enumerate(reader):
        for index,value in enumerate(rows):
            ws.cell(row_index+1,index+1).value=value
wb.save('/Users/liaogege/Desktop/'+ 'csv.xlsm')