我试图使这段代码正常工作,问题是excel文件中的print (...)
数据没有写入,我尝试使用ws.appened (...)
但没有结果
import arcpy
from openpyxl import Workbook
wb = Workbook("C:/Users/Hp/Desktop/ejemplo/VINCULACION_S.xlsx")
ws = wb.active
rows = arcpy.SearchCursor("C:/Users/Hp/Desktop/ejemplo/VH_Dissolve.shp",
fields="COLOR; INTERNO_DE; CLASE_DEMA; COUNT_AREA; SUM_AREA; SUM_LENGTH",
sort_fields="COLOR 222; INTERNO_DE A")
# COLOR, INTERNO_DE, CLASE_DEMA, COUNT_AREA, SUM_AREA y SUM_LENGTH.
for row in rows:
print("Color: {0}, Interno: {1}, Clase:{2}, ContarA: {3}, SumarA: {4}, SumarL: {5}".format(
row.getValue("COLOR"),
row.getValue("INTERNO_DE"),
row.getValue("CLASE_DEMA"),
row.getValue("COUNT_AREA"),
row.getValue("SUM_AREA"),
row.getValue("SUM_LENGTH")))
wb.save('VINCULACION_S.xlsx')
我还尝试在excel文件中从单元格B3:G3开始查找结果数据,但找不到
我用这个密码来解决这个问题
相关问题 更多 >
编程相关推荐