import os import win32com.client as win32 import shutil import openpyxl import time def writedate( path, filename,worksheet,row,column,data_write): print( path + r'/' + filename ) wb = openpyxl.load_workbook( path + r'/' + filename) ws = wb.get_sheet_by_name(worksheet) ws.cell(row=row, column=column).value = data_write wb.save(filename) if __name__ == '__main__': writedate(os.getcwd() + r'/', 'example.xlsx','Sheet1',5,5,342432) writedate(os.getcwd() + r'/', '新建 Microsoft Excel 工作表.xlsx', 'Sheet1', 5, 5, 342432)
主函数子函数python操作excel
最新推荐文章于 2024-04-22 18:55:58 发布