python批量跑plsql_python实现自动化报表(Oracle/plsql/Excel/多线程)

# -*- coding: utf-8 -*-

# Create time: 2019-10-16

# Update time: 2019-11-28

# Version: 1.0

# Version: 2.0 增加多线程/出错自动重新运行模块

# 导入模块

import cx_Oracle

import os

import pandas as pd

import pandas.io.sql as sql

import time

import openpyxl

import xlwings as xw

import logging

import re

import threading

# 获取工作目录

sqlpath = os.getcwd() + '\\'  # 获取当前文件夹目录,若不正确则使用后面的代码直接输入 sqlpath = 'E:\\'

# 设置运行日志

logging.basicConfig(format='%(asctime)s - %(pathname)s] - %(levelname)s: %(message)s', level=logging.INFO, filename=sqlpath+'log.txt')

# 获取系统日期(用于命名文件)

time_start=time.time()

date = time.strftime("%Y%m%d")

# 定义变量

name = '经营日报' # 模版名称

print('开始运行: %s' %na