Python实现table批量转成Excel

---

#批量将table转成Excel
#Author: Changqing Guo
# coding: utf-8
import arcpy
from arcpy import env
from arcpy.sa import *



#features
arcpy.env.workspace = "E:/01"
arcpy.env.overwriteOutput = True

#Set output execl
OutputFeatures = "E:/02"
ta_features = arcpy.ListFiles("*.dbf")

for filename in ta_features:
    print("Processing: " + filename)

    dbffiles = arcpy.env.workspace + "/" + filename
    outFeatures = OutputFeatures + "/"+ filename[:-4]
    arcpy.TableToExcel_conversion(dbffiles, outFeatures + ".xls", Use_field_alias_as_column_header="ALIAS", Use_domain_and_subtype_description="CODE")  

---