# pip install python-docx def first(): from docx import Document doc1 = Document() doc1.add_heading('如何 […] 3. Word 基本操作
from openpyxl import load_workbook from datetime import datetime def get_time(): wb = load_workbook('./ […] 2.9.1 身份证号年龄提取
# 获取随机个人信息写入表格 import sys,os # base_dir=os.path.dirname(os.path.dirname(os.path.abspath(__file__))) # print( […] 2.9 身份证号获取
from openpyxl import load_workbook from openpyxl.styles import PatternFill def dum(): wb = load_workbook( […] 2.8 查询excel重复数据
from openpyxl import Workbook, load_workbook from datetime import date def create_data(): wb = Workbook() sh […] 2.7 统计加班时间
from openpyxl import load_workbook from openpyxl.styles import PatternFill wb = load_workbook(filename=r […] 2.6 隔行变色
from openpyxl import load_workbook,Workbook def create_excel(): wb = load_workbook('./办公自动化/files/工资表.x […] 2.5 工资条案例
import os from openpyxl import Workbook, load_workbook import re import shutil def copy_data(): wb = Workboo […] 2.4 多个excel 合并到多个sheet
import os from openpyxl import Workbook, load_workbook import re import shutil def copy_data(): wb = Workboo […] 2.3 openpyxl 数据合并到一个sheet
import openpyxl from openpyxl import Workbook from openpyxl.chart import ( Reference, Series, AreaChart3D ) […] 2.2 openpyxl 3D图表
from openpyxl import Workbook,load_workbook from openpyxl.chart import BarChart, Series, Reference # wb = Wo […] 2.1 openpyxl 图表案例
# pip install openpyxl # 使用openpyxl from openpyxl.chart import Reference from openpyxl.chart import LineChar […] 2. openpyxl 处理表格
import xlrd from xlutils.copy import copy def get_data(): wb = xlrd.open_workbook('./办公自动化/files/orders […] 1.4 表格的数据拆分
import xlrd from xlutils.copy import copy def read_data(): wb = xlrd.open_workbook('./办公自动化/files/order […] 1.3 数据汇总案例
# pip install xlutils import xlrd import xlutils from xlutils.copy import copy # 打开excel read_book = xlrd.op […] 1.2 xlutils 表格编辑处理