Python学习笔记
terrybekhcam
这个作者很懒,什么都没留下…
展开
-
今天学会了转置EXCEK数据并粘贴
#!/usr/bin/python3import osimport xlwings as xwimport pandas as pdfile = 'C:\\Users\\Administrator\\Desktop\\测试\\统计表.xlsx'app = xw.App(visible = False, add_book = False)wb = app.books.open(file)ws = wb.sheets[0]values = ws.range('E7').options(pd.D.原创 2021-10-10 21:26:43 · 154 阅读 · 0 评论 -
将多个工作簿内容复制到汇总表中(合并工作簿)每日一练
import osimport xlwings as xwimport timeapp = xw.App(visible = True, add_book = False)file_path = 'C:\\Users\\Administrator\\Desktop\\测试\\来源'file_list = os.listdir(file_path)# sheet_name = 'sheet1'for i in file_list: if os.path.splitext(i)[1] =.原创 2021-09-26 23:39:06 · 84 阅读 · 0 评论 -
跨表复制粘贴(往下粘贴)每日一练
import osimport xlwings as xwapp = xw.App(visible = True, add_book = False)wb = app.books.open('C:\\Users\\Administrator\\Desktop\\测试\\测试.xlsx')ws = wb.sheets[0]wc = ws.range('A7').expand('table').valueprint(wc)new_wb = xw.Book('C:\\Users\\Administ.原创 2021-09-26 21:02:58 · 86 阅读 · 0 评论 -
把测试统计表里的所有工作利润簿指定数据复制到测试下面的报所有表(测试目录只有一个表)
import osimport xlwings as xwapp = xw.App(visible = False, add_book = False)file_path = 'C:\\Users\\Administrator\\Desktop\\测试\\来源'file_list = os.listdir(file_path)# workbooks = xw.Book("C:\\Users\\Administrator\\Desktop\\测试统计表")for i in file_list:.原创 2021-09-24 23:10:11 · 76 阅读 · 0 评论 -
2021/9/5 初试PYTHON
OS模块,重命名文件和文件夹。并学会使用try异常语句(注意缩进)在编辑路径时,"\\"="/"# -*- coding: UTF-8 -*-import ospath = "C:/Users/Administrator/Desktop/李欢爱张静.xlsx"newname = "C:\\Users\\Administrator\\Desktop\\张静爱李欢.xlsx"try: os.rename(path,newname)except IOError: print("原创 2021-09-05 21:01:17 · 69 阅读 · 0 评论