terrybekhcam-CSDN博客

原创今天学会了转置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 151

原创将多个工作簿内容复制到汇总表中（合并工作簿）每日一练

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 83

原创跨表复制粘贴（往下粘贴）每日一练

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 85

原创把测试统计表里的所有工作利润簿指定数据复制到测试下面的报所有表（测试目录只有一个表）

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

原创 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 68