Python Loader.close示例

示例#1

文件： batch.py 项目： thesolutionstack/python-playground

def load_excel_to_sql():
    """ The database is configured in config.json in the tempfiles directory """
#     drop_create_tables()
    excelSheet = r'd:\$temp\Onion Lake SK wells.xlsx'
#     excelSheet = config.get_file_dir() +  'database new.xlsx'
    loader = Loader()
    loader.connect()
    loader.open_excel(excelSheet)
    loader.load_all_sheets()
    loader.close()

示例#2

文件： batch.py 项目： lshumlich/python-playground

def load_excel_to_sql():
    """ The database is configured in config.json in the tempfiles directory """
    #     drop_create_tables()
    excelSheet = r'd:\$temp\Onion Lake SK wells.xlsx'
    #     excelSheet = config.get_file_dir() +  'database new.xlsx'
    loader = Loader()
    loader.connect()
    loader.open_excel(excelSheet)
    loader.load_all_sheets()
    loader.close()