python结合Arcpy处理EXCEL数据生成多边形

看书的时候，遇见了如下数据：

原书中是用VB写的宏，然后存储到txt文件中。

试着用python加Arcpy脚本处理了一下，python对excel处理的教程见链接，这里粘贴一下处理的代码：

import xlrd
import xlwt
import arcpy

xlsPath = r"C:\Users\Administrator\Desktop\Polygon.xls"
data = xlrd.open_workbook(xlsPath)

table = data.sheets()[0]#通过索引顺序获取
cols = table.col_values(5)
nrows = table.nrows
point = arcpy.Point()
array = arcpy.Array()

polygonGeometryList = []
for i in range(1,nrows):
    str = table.cell(i,5).value
    points = str.split(u'；')
    for j in points:
        xy = j.split(',')
        print xy[0]
        print xy[1]
        print '\n'
        point.X = float(xy[0]);point.Y = float(xy[1])
        array.add(point)
    polygon = arcpy.Polygon(array)
    polygonGeometryList.append(polygon)
    array.removeAll()
arcpy.CopyFeatures_management(polygonGeometryList, "d:\\polygon.shp")

print 'over'

效果图：

转载自：https://blog.csdn.net/sprintwater/article/details/39672035