Arcpy读取excel生成shp文件

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import openpyxl as excel
import arcpy
import os

## 读取excel生成shp文件
def excelToShp(path):

    arcpy.env.workspace = os.getcwd()
    outName = r"polyline.shp"
    polylineGeometryList = [] # a list to hold the PointGeometry objects
    spRef = arcpy.SpatialReference(4326)


    ## 读取excel,获取站点关联线段
    excelFile=path
    wb=excel.load_workbook(excelFile)
    ## 读取第一行，获取列头
    sheet=wb["Sheet1"]
    rows=sheet.max_row
    columns=sheet.max_column
    dic={}
    ## 存储列名与列号的对应
    for i in range(1,columns+1):
        dic[sheet.cell(row=1,column=i).value]=i

    ## 遍历剩余的行，根据对应关系求坐标
    polylinGeometryList=[]
    for i in range(2,rows+1):
        start_n=str(sheet.cell(i,dic['start_n']).value)

        if start_n is None:
            continue
        
        ## 开始坐标和结束坐标
        start_lon=sheet.cell(i,dic['start_lon']).value
        start_lat=sheet.cell(i,dic['start_lat']).value
        end_lon=sheet.cell(i,dic['end_lon']).value
        end_lat=sheet.cell(i,dic['end_lat']).value
        ## 构建线段
        startPoint=arcpy.Point(float(start_lon), float(start_lat))
        endPoint=arcpy.Point(float(end_lon), float(end_lat))
        array=arcpy.Array()
        array.append(startPoint)
        array.append(endPoint)
        polylinGeometry = arcpy.Polyline(array,spRef)
        polylinGeometryList.append(polylinGeometry)
    
    ## 保存内容
    arcpy.CopyFeatures_management(polylinGeometryList, outName)

    print 'done'



if __name__=='__main__':

    excelPath=r"D:\zlc\hdxs\filedata\creat_test.xlsx"
    excelToShp(excelPath)

import os
## 创建路径
if os.path.isdir(path + '/' + x):  
    print(x + ' exists.')
else:
    os.mkdir(path + '/' + x) 
    print(x + ' created.')

## 拼接路径
os.path.join('/my/root/directory', 'in', 'here')