import os sys.path.append(r'C:\WebGIS\PythonLibraries') import arial10 import cleanup import datetime from xlwt import Workbook, Borders, Font, XFStyle # env arcpy.env.qualifiedFieldNames = False arcpy.env.overwriteOutput = True # Out Path PATH = r'C:\inetpub\wwwroot\TempFiles' PATH_URL = 'http://lt0212x1g2676/TempFiles' cleanup.remove_files(PATH, 1/96.0) cleanup.remove_folders(PATH, 1/96.0) def CreateExcelSpreadsheet(table, output_excel, use_alias=True): """Exports table to excel Required: table -- input table output_excel -- output excel table (.xlsx, .xls) Optional: use_alias -- use field alias name for column headers. Default is True """ # build field dict fieldNames = [(f.name, f.aliasName) for f in arcpy.ListFields(table) if f.type != 'Geometry'] fields = [f[1] if use_alias in ('true', True) else f[0] for f in fieldNames] widths = {i: arial10.fitwidth(f) + 1024 for i,f in enumerate(fields)}
sys.path.append(r'C:\WebGIS\PythonLibraries') import restapi import arcpy import os import cleanup import zipfile import json import time PATH = r'C:\inetpub\wwwroot\TempFiles' DATE = time.strftime('%Y%m%d%H%M%S') PATH_URL = 'http://lt0212x1g2676/TempFiles' # clean up temp files folder cleanup.remove_files(PATH, 1/96.0) cleanup.remove_folders(PATH, 1/96.0, del_gdb=True) def zipdir(path, out_zip=''): """zips a folder and all subfolders Required: path -- folder to zip Optional: out_zip -- output zip folder. Default is path + '.zip' """ rootDIR = os.path.basename(path) if not out_zip: out_zip = path + '.zip' else: if not out_zip.strip().endswith('.zip'):