xlwr_GPT

import os
import pandas as pd
from openpyxl import load_workbook

# 定义要替换的内容
old_value = 'old_value'
new_value = 'new_value'

# 定义要替换的sheet和行列
sheet_name = 'Sheet1'
row_num = 2
col_num = 3

# 指定目录路径
dir_path = '/path/to/directory'

# 遍历目录下的所有Excel文件
for filename in os.listdir(dir_path):
    if filename.endswith('.xlsx'):
        filepath = os.path.join(dir_path, filename)

        # 读取Excel文件并选择指定的sheet
        wb = load_workbook(filepath)
        ws = wb[sheet_name]

        # 用pandas读取数据
        df = pd.DataFrame(ws.values)

        # 替换指定行列的内容
        df.iloc[row_num-1, col_num-1] = new_value if df.iloc[row_num-1, col_num-1] == old_value else df.iloc[row_num-1, col_num-1]

        # 将修改后的数据写入Excel文件
        for r in dataframe_to_rows(df, index=False, header=False):
            ws.append(r)
        wb.save(filepath)
 

import os
import pandas as pd

folder_path = "D:/task/4600/script/sdk3.0/spec"
sheet_name = "Test case"
replace_row = 3
replace_col = 6
replace_value = "9.0"

for file_name in os.listdir(folder_path):
    if file_name.endswith(".xlsx") or file_name.endswith(".xls"):
        file_path = os.path.join(folder_path, file_name)
        df = pd.read_excel(file_path, sheet_name=sheet_name)
        df.iloc[replace_row-1, replace_col-1] = replace_value
    
        with pd.ExcelWriter(file_path) as writer:
            df.to_excel(writer, index=False)
 

import os 
import openpyxl  
from openpyxl.drawing.image import Image  

folder_path='D:/编程/0329/1'
folder_path2='D:/编程/0329/convert'

for file_name in os.listdir(folder_path):  
    i=0
    if file_name.endswith('.xlsx') or file_name.endswith('.xls'):  
        file_path = os.path.join(folder_path, file_name)  
          
        # 读取 Excel 文件  
        wb = load_workbook(filename=file_path) 
        # 打开Excel文件  
        #wb = openpyxl.load_workbook()  
        
        # 选择指定的sheet  
        sheet = wb['Test case']  
        
        # 替换指定行列的内容  
        sheet['A1'] = 'Hello, World!'  
        sheet['B1'] = 123
        
        sheet2 = wb['2']  
        
        # 替换指定行列的内容  
        sheet2['A1'] = 'Hello, World!'  
        sheet2['B1'] = 123
        
        # 插入图片  
        '''
        img = Image('image.png')  
        img.width = 100  
        img.height = 100  
        ws = wb.active  
        ws.add_image(img, 'F1')  ##
        '''
        # 保存文件  
        #fileList = file_name.split(".")[0]
        wb.save(fileList+)