nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export Attributes from Arcmap without Geometry fields

2Quiker

I need to export attributes from a certain layer in Arcmap but without the OID & Geometry fields to excel.

I've tried the following bet i am getting error ("AttributeError: DescribeData: Method areaFieldName does not exist") on line 15. I would appreciate any help with the code, thanks.

import arcpy
import os

arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
lyr = arcpy.mapping.ListLayers(mxd, "Notified")[0]

arcpy.env.workspace = os.path.dirname(mxd.filePath)
wp = os.path.dirname(mxd.filePath)

fc = "Notified"
desc = arcpy.Describe(fc)
f = desc.fields
fields = [f.name for f in f if f.name != desc.OIDFieldName and f.type != 'Geometry' and f.name != desc.areaFieldName and f.name != desc.lengthFieldName]
for fld in fields:  
    fields.remove(fields)

arcpy.MakeQueryTable_management(fc, "tmp_table", "NO_KEY_FIELD")‍‍‍‍‍‍‍‍
arcpy.TableToExcel_conversion("tmp_table", Notified_xls) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

JB1234510

A working possibility could be to convert to numpy array, then use pandas to convert the array to excel?

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

inTable <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"yourpath\Export_Output.shp"</SPAN>

outTable1 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"yourpath\export.xls"</SPAN>

fieldNames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PARCEL_NO"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OwnerName"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Address"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"City"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"State"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ZipCode"</SPAN><SPAN class="punctuation token">]</SPAN>

arr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>FeatureClassToNumPyArray<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> fieldNames<SPAN class="punctuation token">)</SPAN>

df <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>arr<SPAN class="punctuation token">)</SPAN>

df1 <SPAN class="operator token">=</SPAN> df<SPAN class="punctuation token">.</SPAN>to_excel<SPAN class="punctuation token">(</SPAN>outTable1<SPAN class="punctuation token">,</SPAN> index<SPAN class="operator token">=</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

Has anyone tried the editable property? aka, only export those that are editable in conjunction with some of the others.

editable

(Read and Write)

The editable state: True if the field is editable.

Boolean

2Quiker

I am still have the the FID, Shape_Lenth & Shape_Area fields after the export to Excel after using what you posted

2Quiker

Ya I agree i could just open the excel spreadsheet and delete them if i were only doing it so often. I usually run this process about 10 times a week. So i was trying to make it as stream lined as possible.

JoeBorgione

I shy away from field mapping as well. If you don't mind a hack, you could do a table to excel and then open your new excel worksheet and just delete the fields you don't want.....

jskinner

In your code you are removing the fields from the list, but you are not applying the fields list to any function afterwards. I believe you will have to do some field mapping. Here is an example that I was able to get to work:

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Set data path</SPAN>
intable <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\temp\python\test.gdb\airports"</SPAN>

<SPAN class="comment token"># Create a fieldinfo object</SPAN>
fieldInfo <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FieldInfo<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Get the fields from the input</SPAN>
fields<SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fields<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'OID'</SPAN> <SPAN class="operator token">and</SPAN> field<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'Shape'</SPAN><SPAN class="punctuation token">:</SPAN>
       fieldInfo<SPAN class="punctuation token">.</SPAN>addField<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VISIBLE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">==</SPAN> <SPAN class="string token">'OID'</SPAN><SPAN class="punctuation token">:</SPAN>
       fieldInfo<SPAN class="punctuation token">.</SPAN>addField<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"HIDDEN"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Create table view</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"airports_view"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> fieldInfo<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Export to Excel</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>conversion<SPAN class="punctuation token">.</SPAN>TableToExcel<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"airports_view"</SPAN><SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">"C:\TEMP\Python\airports.xlsx"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

For some reason the OID is always added, so I had to add this as HIDDEN.

2Quiker

Jake,

Thanks for the recommendation but I would have thought that just dropping or removing the fields would be easier.

I didn't want to do the field mapping.

jskinner

I would recommend executing the Table to Table tool and export the layer to a File Geodatabase. You can remove the OID using the Field Mapping paramter (the geometry should already be removed). Then execute the Table to Excel tool on the geodatabase table. After executing each of these, you can copy the python commands and paste them into your script.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.