帖子
|
我得到了这段代码作为一个解决方案后导入arcpy导入openpyxl作为px def main(): wb = px.load_workbook(r"C:\Users\Hp\Desktop\Ejemplo\VINCULACION_S.xlsx") ws = wb['VINCULACION_SH_NUE'] in_features = r"C:\Users\Hp\Desktop\Ejemplo\ vh_solve。使用arcpy.da执行row_num = 3。搜索Cursor( in_features, ["COLOR", "INTERNO_DE", "CLASE_DEMA", "COUNT_AREA", "SUM_AREA", "SUM_LENGTH"], ) as cursor: for row in cursor: ws.cell(row=row_num, column=2).value = row[0] ws.cell(row=row_num, column=3).value = row[1] ws.cell(row=row_num, column=4).value = row[2] ws.cell(row=row_num, column=6).value = row[3] ws.cell(row=row_num, column=7).value = row[4] ws.cell(row=row_num, column=8).value = row[5] row_num += 1 wb.save(r"C:\Users\Hp\Desktop\Ejemplo\VINCULACION_S.xlsx") if __name__ == "__main__": main()
...查看更多
06-08-2021上午07:34
|
0
|
0
|
4667
|
帖子
|
我试图使这段代码工作,问题是在excel文件打印(…)数据没有被写入,我已经尝试使用ws。发生了,但没有结果。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_resolve . "轴马力”,字段= "颜色;INTERNO_DE;CLASE_DEMA;COUNT_AREA;SUM_AREA;SUM_LENGTH", sort_fields="COLOR 222;) #颜色,颜色,类别,计数区域,面积和长度。打印(“颜色:{0},Interno: {1}, Clase:{2}, ContarA: {3}, SumarA: {4}, sumar:{5}”。形式at( 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') I have also tried to locate the results data in the excel file from cell B3: G3 onwards but I can't find it.
...查看更多
06-07-2021下午07:25
|
0
|
2
|
4735
|
帖子
|
我得到了这段代码作为后导入arcpy导入openpyxl作为px def main(): wb = px.load_workbook(r"C:\Users\Hp\Desktop\Ejemplo\VINCULACION_S。xlsm", read_only=False, keep_vba=True) ws = wb['VINCULACION_SH_NUE'] in_features = r"C:\Users\Hp\Desktop\Ejemplo\VH_Dissolve。使用arcpy.da执行row_num = 3。搜索Cursor( in_features, ["COLOR", "INTERNO_DE", "CLASE_DEMA", "COUNT_AREA", "SUM_AREA", "SUM_LENGTH"], ) as cursor: for row in cursor: ws.cell(row=row_num, column=2).value = row[0] ws.cell(row=row_num, column=3).value = row[1] ws.cell(row=row_num, column=4).value = row[2] ws.cell(row=row_num, column=6).value = row[3] ws.cell(row=row_num, column=7).value = row[4] ws.cell(row=row_num, column=8).value = row[5] row_num += 1 wb.save(r"C:\Users\Hp\Desktop\Ejemplo\VINCULACION_S.xlsm")
...查看更多
06-06-202105:34点
|
1
|
0
|
1450
|
帖子
|
@BlakeTerhune是的,我把数据从.shp写在。xlsm, excel书总是一个现有的文件…为了获得.shp文件,我从AutoCAD MAP 3D绘图中导出它,然后在ArcMap中工作。现在我要查找的查询是从.shp文件中获取表属性,并将它们添加到已经存在的Excel文件“VINCULACION_S.xlsm”中。
...查看更多
06-03-202134点
|
0
|
1
|
1393
|
帖子
|
这个想法是在SHP文件中执行查询,并将查询结果写入现有的Excel文件中。注意:更新问题,附加.shp和.xlsm文件。
...查看更多
06-03-2021福音11:24我
|
0
|
3.
|
1398
|
帖子
|
@JoeBorgione感谢你对我的帖子感兴趣。我想做的是从excel .xlsm文件中查询.shp文件的字段,也就是说,避免重复和手动从arcmap复制属性表到工作的.xlsm文件的过程,例如,查询和写入显示在arcmap中并包含在VHDissolve353中的这个属性表的值。shp文件从我的Excel VINCULACION。注意:属性表和excel中的表有相同的字段。@BlakeTerhune你用python向我建议的过程听起来很有趣,你能帮助我实现它的方法或例子吗?谢谢你!
...查看更多
06-03-202109:13我
|
0
|
5
|
1466
|
帖子
|
我想知道是否有任何方法通过Python从一个.xlsm文件(启用宏的Excel)查询一个.shp文件(ArcMap)的属性表的字段,这是因为我目前重复做和手动是从ArcMap复制属性表到我的Excel文件“VINCULACION_S.xlsm”。我想要复制的一个属性表是我在这个图像中显示的,指向已经提到的.xlsm文件,我在这个图像中显示了这个文件。这显然是一个很好的开始#设置本地变量inTable = outTable outXLS = VHFolder + "/Vinculacion_S.xlsx" #这是我必须给出文件路径和文件名的地方#执行TableToExcel arcpy。TableToExcel_conversion(inTable, outXLS)版本
...查看更多
06-03-202108:46我
|
0
|
10
|
1677
|