Query the fields of an attribute table of a .shp file (ArcMap) from an .xlsx file with Python

Question

What I want to do is query the fields of a .shp file from an Excel .xlsx file, that is, avoid the repetitive and manual process of copying the attribute table from ArcMap to the working .xlsx file,

For example, query and write the values ​​of this attribute table displayed in arcmap and contained in the VHDissolve.shp file from my Excel VINCULACION.xlsx file

Note: The attribute table and the table in Excel have the same fields.

This is a good start apparently

# Set local variables
inTable = outTable
outXLS = VHFolder + "/Vinculacion_S.xlsx" #this is where I had to give the file path and then the file name
Execute TableToExcel
arcpy.TableToExcel_conversion(inTable, outXLS)
ersion(inTable, outXLS)

Annex link with the .shp and .xlsm files https://drive.google.com/file/d/1z7tbOCxQ0Xjl24tCCmfKMpcgnuomdHT-/view?usp=sharing

Answer 1

Your code should look something more like this:

import arcpy
import openpyxl as px
def main():
    wb = px.load_workbook(r"C:\Downloads\Ejemplo\VINCULACION.S.xlsx")
    ws = wb["VINCULACION_SH_NUE"]
    in_features = r"C:\Downloads\Ejemplo\VH_Dissolve.shp"
row_num = 3
with arcpy.da.SearchCursor(
    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:\Downloads\Ejemplo\VINCULACION_v2.xlsx")



if name == "main":
    main()

Answer 2

The ArcMap Table To Excel tool:

converts only to Microsoft Excel 5.0/95 Workbook (.xls) format.

The ArcGIS Pro Table To Excel tool:

Converts a table to a Microsoft Excel file (.xls or .xlsx).

Neither of these two applications in the ArcGIS Desktop product write to .xlsm.

There is no mention of .xlsm in either of these two Esri support pages:

• How To: Export an attribute table from ArcMap to Microsoft Excel
• How To: Export an attribute table from ArcGIS Pro to Microsoft Excel

Consequently, any conversion from .xls or .xlsx to .xlsm will need to be performed outside of ArcGIS Desktop. Since you are looking to do this using Python I think any question about that will need to be researched/asked at Stack Overflow.

Answer 3

This could be the solution to the post, I still can't integrate Opelpyxl to Python from ArcMap, or Arcpy to IDLE from Python

import arcpy
from openpyxl import Workbook
wb = Workbook("C:/Users/Hp/Desktop/ejemplo/VINCULACION_S.xlsx")
ws =  wb[('VH_NUE']
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:
    ws.append("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)