Exemplos de VisualBlock.Visual_Block_Info em Python

Exemplo n.º 1

Arquivo: studio_unzip.py Projeto: woobrain/some_test

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", str(e))

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", str(e))

# -*- 解压文件
try:
    visual_block.Visual_Block_Info("解压文件", 1, 0, "正在执行")

    import rpa.file_folder
    rpa_f19e96_array_string = rpa.file_folder.unzip_file(
        zip_src=r"C:\\Users\\Administrator\\Desktop\\poc用例.zip",
        dst_dir=None,
        cover=True)

except Exception as e:
    visual_block.Visual_Block_Info("解压文件", 1, 2, e)

    log.error("[%s] %s", "解压文件", str(e))
    raise e

# -*- 流程结束
try:

Exemplo n.º 2

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", str(e))

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", str(e))

# -*- 打开 Excel 文档
try:
    visual_block.Visual_Block_Info("打开 Excel 文档", 1, 0, "正在执行")

    import rpa.excel
    rpa_ac8955_excel = rpa.excel.open(
        r"C:\\Users\\Administrator\\Desktop\\POC 用例.xls",
        visible=True,
        readonly=False,
        pass_word="",
        wps=False)

except Exception as e:
    exception_capture(__errorCapturePath, "打开 Excel 文档", __taskId)
    visual_block.Visual_Block_Info("打开 Excel 文档", 1, 2, str(e))

    log.error("[%s] %s", "打开 Excel 文档", str(e))
    raise e

Exemplo n.º 3

Arquivo: test_2.py Projeto: woobrain/some_test

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", e.message)

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", e.message)

# -*- 打开信息表文档
try:
    visual_block.Visual_Block_Info("打开信息表文档", 1, 0, "正在执行")

    import rpa.excel

    rpa_36308c_excel = rpa.excel.open(
        r"C:\\Users\\Administrator\\Desktop\\all_test\\orientation-master-69c44478cbf4319c878dd001239880dc717ac6fb\\rpa\\精进五道题\\题目二\\学历表.xlsx",
        visible=True,
        readonly=False,
        pass_word="",
        wps=True)

except Exception as e:
    visual_block.Visual_Block_Info("打开信息表文档", 1, 2, e)

    log.error("[%s] %s", "打开信息表文档", e.message)
    raise e

Exemplo n.º 4

Arquivo: my_test.py Projeto: woobrain/some_test

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", str(e))

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", str(e))

# -*- 打开/新建 Excel 文档
try:
    visual_block.Visual_Block_Info("打开/新建 Excel 文档", 1, 0, "正在执行")

    import rpa.excel

    rpa_c7be40_excel = rpa.excel.create(visible=True, wps=False)

except Exception as e:
    visual_block.Visual_Block_Info("打开/新建 Excel 文档", 1, 2, e)

    log.error("[%s] %s", "打开/新建 Excel 文档", str(e))
    raise e

# -*- 启动浏览器
try:
    visual_block.Visual_Block_Info("启动浏览器", 2, 0, "正在执行")

Exemplo n.º 5

Arquivo: toushi.py Projeto: woobrain/some_test

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", str(e))

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", str(e))

# -*- 打开/新建 Excel 文档
try:
    visual_block.Visual_Block_Info("打开/新建 Excel 文档", 1, 0, "正在执行")

    import rpa.excel
    rpa_f2fd63_excel = rpa.excel.open(
        r"C:\\Users\\Administrator\\Desktop\\四川picc\\new\\保费匹配表.xlsx",
        visible=True,
        readonly=False,
        pass_word="",
        wps=False)

except Exception as e:
    exception_capture(__errorCapturePath, "打开/新建 Excel 文档", __taskId)
    visual_block.Visual_Block_Info("打开/新建 Excel 文档", 1, 2, str(e))

    log.error("[%s] %s", "打开/新建 Excel 文档", str(e))
    raise e

Exemplo n.º 6

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", e.message)

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", e.message)

# -*- 打开/新建 Excel 文档
try:
    visual_block.Visual_Block_Info("打开/新建 Excel 文档", 1, 0, "正在执行")

    import rpa.excel

    rpa_7218a5_excel = rpa.excel.open(
        r"C:\\Users\\Administrator\\Desktop\\all_test\\orientation-master-69c44478cbf4319c878dd001239880dc717ac6fb\\rpa\\精进五道题\\题目一\\王老师学生表.xlsx",
        visible=True,
        readonly=False,
        pass_word="",
        wps=True)

except Exception as e:
    visual_block.Visual_Block_Info("打开/新建 Excel 文档", 1, 2, e)

    log.error("[%s] %s", "打开/新建 Excel 文档", e.message)
    raise e

Exemplo n.º 7

    }

except Exception as e:
    log.error("[%s] %s", "参数面板", e.message)

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", e.message)

# -*- 打开流水账单文档
try:
    visual_block.Visual_Block_Info("打开流水账单文档", 1, 0, "正在执行")

    import rpa.excel

    rpa_141104_excel = rpa.excel.open(r"C:\\Users\\Administrator\\Desktop\\题目五\\银行流水.xls", visible=True, readonly=False,
                                      pass_word="", wps=True)

except Exception as e:
    visual_block.Visual_Block_Info("打开流水账单文档", 1, 2, e)

    log.error("[%s] %s", "打开流水账单文档", e.message)
    raise e

# -*- 打开CSV文档
try:
    visual_block.Visual_Block_Info("打开CSV文档", 2, 0, "正在执行")

Exemplo n.º 8

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", e.message)

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", e.message)

# -*- 新建 Excel 文档
try:
    visual_block.Visual_Block_Info("新建 Excel 文档", 1, 0, "正在执行")

    import rpa.excel

    rpa_6a4539_excel = rpa.excel.create(visible=True, wps=True)

except Exception as e:
    visual_block.Visual_Block_Info("新建 Excel 文档", 1, 2, e)

    log.error("[%s] %s", "新建 Excel 文档", e.message)
    raise e

# -*- 设置列宽
try:
    visual_block.Visual_Block_Info("设置列宽", 2, 0, "正在执行")

Exemplo n.º 9

Arquivo: zifu.py Projeto: woobrain/some_test

    }

except Exception as e:
    log.error("[%s] %s", "参数面板", e.message)

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", e.message)

# -*- 打开/新建 Excel 文档
try:
    visual_block.Visual_Block_Info("打开/新建 Excel 文档", 1, 0, "正在执行")

    import rpa.excel

    rpa_785890_excel = rpa.excel.create(visible=True, wps=True)

except Exception as e:
    visual_block.Visual_Block_Info("打开/新建 Excel 文档", 1, 2, e)

    log.error("[%s] %s", "打开/新建 Excel 文档", e.message)
    raise e

# -*- Excel行数
try:
    visual_block.Visual_Block_Info("Excel行数", 2, 0, "正在执行")

Exemplo n.º 10

Arquivo: aa_test.py Projeto: woobrain/some_test

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", str(e))

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", str(e))

# -*- 启动浏览器
try:
    visual_block.Visual_Block_Info("启动浏览器", 1, 0, "正在执行")

    option = ChromeOptions()
    prefs = {'safebrowsing.enabled': True}
    option.add_experimental_option('prefs', prefs)
    rpa_f5e47a_browser = Chrome(option)

except Exception as e:
    visual_block.Visual_Block_Info("启动浏览器", 1, 2, e)

    log.error("[%s] %s", "启动浏览器", str(e))
    raise e

# -*- 浏览器最大化
try:
    visual_block.Visual_Block_Info("浏览器最大化", 2, 0, "正在执行")

Exemplo n.º 11

Arquivo: test.py Projeto: woobrain/some_test

    }

except Exception as e:
    log.error("[%s] %s", "参数面板", str(e))

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", str(e))

# -*- 变量注释说明
try:
    visual_block.Visual_Block_Info("变量注释说明", 1, 0, "正在执行")

    sys.coinit_flags = 0
    # "tb_qs" : []     # 投保去重
    # "ts_one" : []    # 汇总表透视表1
    # "ts_two" : []    # 收付费明细表透视表2
    # "p_true" : []    # 匹配表得到数据一致列表
    # a_dic = {}       # 中间对汇总表去重以及金额相加所使用的字典
    # p_one = []       # 匹配表中透视表1的ABC三列的二维列表
    # b_dic = {}       # 中间对收付费明细表去重以及金额相加所使用的字典
    # p_two = []       # 匹配表中透视表2的F列的列表
    # "mx_true" : []   # 与收付费明细表的数据一致列表
    # "mx_false" : []  # 与收付费明细表数据不一致列表
    # "count" : 0      # 导入笔数
    # "cny_sum" : 0.0  # 导入金额
    # "sg_true" : []   # 手工数据匹配数据一致列表

Exemplo n.º 12

Arquivo: zimu.py Projeto: woobrain/some_test

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", str(e))

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", str(e))

# -*- 启动浏览器
try:
    visual_block.Visual_Block_Info("启动浏览器", 1, 0, "正在执行")

    option = ChromeOptions()
    prefs = {'safebrowsing.enabled': True}
    option.add_experimental_option('prefs', prefs)
    rpa_1a41b1_browser = Chrome(option)

except Exception as e:
    visual_block.Visual_Block_Info("启动浏览器", 1, 2, e)

    log.error("[%s] %s", "启动浏览器", str(e))
    raise e

# -*- 打开网页
try:
    visual_block.Visual_Block_Info("打开网页", 2, 0, "正在执行")

Exemplo n.º 13

Arquivo: toushi_test.py Projeto: woobrain/some_test

    PANEL_VARS = {}

except Exception as e:
    log.error("[%s] %s", "参数面板", str(e))

# -*- 传入的JSON
try:

    update_panel(sys.argv, PANEL_VARS)

except Exception as e:
    log.error("[%s] %s", "传入的JSON", str(e))

# -*- 打开 Excel 文档
try:
    visual_block.Visual_Block_Info("打开 Excel 文档", 1, 0, "正在执行")

    import rpa.excel

    rpa_1fa051_excel = rpa.excel.open(
        r"C:\\Users\\Administrator\\Desktop\\保费匹配表.xlsx",
        visible=True,
        readonly=False,
        pass_word="",
        wps=False)

except Exception as e:
    exception_capture(__errorCapturePath, "打开 Excel 文档", __taskId)
    visual_block.Visual_Block_Info("打开 Excel 文档", 1, 2, str(e))

    log.error("[%s] %s", "打开 Excel 文档", str(e))