Python Excel
Python deal with Excel
weixin_46655338
这个作者很懒,什么都没留下…
展开
-
python处理Excel(1):报表结构转换处理各经联社收支明细表(支出项目汇总表)
python处理Excel:报表结构转换处理各经联社收支明细表(支出项目汇总表)一、#coding=utf-8#Transformation structure报表结构转换import xlrd, xlwt, pyautogui, time, pyperclip, easygui, os, tkinter, io,pandas,shutil,re#import autopy as at#file= tkinter.filedialog.askopenfile()#选择打开什么文件,返回IO流原创 2022-05-17 13:48:14 · 513 阅读 · 0 评论 -
Python处理Excel(4):正则查找Excel复制行
Python处理Excel(4):正则查找Excel复制行#coding=utf-8#正则查找Excel复制行import xlrd, xlwt, xlwings, pyautogui, time, pyperclip, easygui, os, tkinter, io,pandas,shutil,refrom tkinter import filedialog,ttkfrom openpyxl import load_workbook #pip install openpyxl#impo原创 2022-05-17 13:42:45 · 411 阅读 · 0 评论 -
Python处理Excel(6):处理清产核资表格(1)
Python处理Excel(6):处理清产核资表格一、复制应收款#coding=utf-8#复制粘贴应收款import xlrd, xlwt, xlwings, pyautogui, time, pyperclip, easygui, os, tkinter, io,pandas,shutil,re, osfrom tkinter import filedialog,ttkfrom openpyxl import load_workbook #pip install openpyxlfr原创 2022-05-17 13:42:18 · 214 阅读 · 0 评论 -
Python处理Excel(7):处理清产核资表格(2)合并单元格等
Python处理Excel(7):处理清产核资表格(2)合并单元格等一、清空单元格#coding=utf-8#合并单元格,此文档尝试了用增加行import xlrd, xlwt, xlwings, pyautogui, time, pyperclip, easygui, os, tkinter, io,pandas,shutil,re, osfrom tkinter import filedialog,ttkfrom openpyxl import load_workbookfrom ope原创 2022-05-17 13:41:36 · 291 阅读 · 0 评论