ArcGIS中利用python语言基于excel批量添加字段，附件赠送完整脚本工具

import xlrd import arcpy #读取Excel表作为参数输入hxj xls_path=arcpy.GetParameterAsText(0) data=xlrd.open_workbook(xls_path) #读取要批量添加字段的图层gisthink_idea shp_path=arcpy.GetParameterAsText(1) #shp_path=r'C:\Users\ygb_709\Desktop\test20201123\test.shp' #读取excel中的sheet表名gisthink_idea sheetname=arcpy.GetParameterAsText(2) table=data.sheet_by_name(sheetname) print(table.row_values(0)) for txt in table.row_values(1): print txt print("输出行数：") print table.nrows for i in range(1,table.nrows): print table.row_values(i)[1] print table.row_values(i)[3] arcpy.AddField_management(shp_path,field_name=table.row_values(i)[1],field_type=table.row_values(i)[2],field_precision=table.row_values(i)[3],field_scale=table.row_values(i)[4],field_length=table.row_values(i)[5],field_alias=table.row_values(i)[6],field_is_nullable=table.row_values(i)[7],field_is_required=table.row_values(i)[8]) arcpy.AddMessage("gisthink成功添加字段：".decode('utf-8')+table.row_values(i)[1]) arcpy.AddMessage("已完成idea")