用pyautogui从EXCEL自动录入数据到WEB网页

机械地手工录入数据是烦死人的工作。

让PYTHON程序帮你做。练习pyautogui，openpyxl，logging的用法。使用 …\pyinstaller -F abc.py 打包程序。

源码如下

import os
import sys
import openpyxl
import re
import time
import pyautogui as pyag
import logging
import logging.handlers


def getlogger(fn="info"):
    logger = logging.getLogger(__name__)
    logger.setLevel(logging.DEBUG)
    formatter = logging.Formatter(
        '%(asctime)s %(levelno)s - %(name)s.%(funcName)s.%(lineno)d - %(message)s')

    stream_handler = logging.StreamHandler()  # 标准流处理器
    stream_handler.setLevel(logging.DEBUG)
    stream_handler.setFormatter(formatter)
    logger.addHandler(stream_handler)  # 添加处理器

    file_handler = logging.handlers.RotatingFileHandler(
        filename=fn + ".log", maxBytes=5*1024*1024, backupCount=5)
    file_handler.setLevel(logging.INFO)
    file_handler.setFormatter(formatter)
    logger.addHandler(file_handler)

    return logger


def GoWork():
    fn = r"\铭牌信息表.xlsx"
    if os.path.exists(os.path.join(Base_DIR, fn)):
        fn = os.path.join(Base_DIR, fn)
    else:
        fn = r"D:\铭牌信息表.xlsx"
    wb = openpyxl.load_workbook(fn)
    logger.info("打开表格：" + wb.sheetnames[0])
    wbsh = wb.worksheets[0]
    row &