现有的word文档中新增内容:https://www.jianshu.com/p/48b368a9ca3f
现有的ppt文件中新增内容:https://www.jianshu.com/p/531af9ee77dc
现有的word文件转化成pdf:https://www.jianshu.com/p/b4c33b7044d0
1.安装插件
pip install xlrd
pip install openpyxl
2.具体方法:
这个方法只适合全部都是文字的,图片会丢失:
import xlrd
def updateExcel():
filename = 'C:\\Users\\17546\\Desktop\\5M.xlsx'
rb = xlrd.open_workbook(filename)
wb = copy(rb)
ws = wb.get_sheet(0)
# 第几行,第几列,添加的内容(行、列从0计数)
ws.write(1, 0, 'aa')
wb.save(filename)
这个方法很通用:
from openpyxl import load_workbook
import time
def updateExcel(self):
filename = r'wps/test.xlsx'
wb = load_workbook(filename)
ws = wb.get_sheet_by_name('Sheet1')
ws['J2'] = int(time.time())
wb.save(filename)








网友评论