Export layers of a gdb as excel table

[JoelRodriguez95]

Hello everybody,

I'm new in this world of arcpy and I would like poder export all of layer of a gbd to an excel format, I tried with several this foro's scripts but I can't get the result, this is my script actual but not funcionate.

import arcpy

from arcpy import env

env.workspace = r" C:\Users\LAP77\Desktop\JR\Veg_Hidro_Final.gdb"

output_folder = of = r" C:\Users\LAP77\Desktop\JR\Veg_Hidro_Final\Excel"

for fc in arcpy.ListFeatureClasses("*"):

        fc_name= of+ "\\"+fc+".xls" 

        print(fc_name)

        arcpy.TableToExcel_conversion(fc,fc_name, "NAME", "CODE")

[DavinWalker2]

What error are you getting when you run the script?

[JoelRodriguez95]

Thanks for your time!

This is the error:

>>> import arcpy
... from arcpy import env
... env.workspace = r" C:\Users\LAP77\JR\Veg_Hidro_Final\Veg_Hidro_Final.gdb"
... output_folder = of = r" C:\Users\LAP77\JR\Veg_Hidro_Final\Excel"
... for fc in arcpy.ListFeatureClasses("*"):
...         fc_name= of+ "\\"+fc+".xls"	
...         print(fc_name)
...         arcpy.TableToExcel_conversion(fc,fc_name, "NAME", "CODE")
...         
 C:\Users\LAP77\JR\Veg_Hidro_Final\Excel\Veg_Hidro_Final.xls
Runtime error  Traceback (most recent call last):   File "<string>", line 8, in <module>   File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\conversion.py", line 81, in TableToExcel     raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Table: Dataset Veg_Hidro_Final does not exist or is not supported Failed to execute (TableToExcel).  

[Anonymous User]

TableToExcel takes a Table View as an input.  You need to make a table view from your fc and pass that into the function.  See my post below for the full code.

fc_table_view = arcpy.MakeTableView_management(fc, "tview")
arcpy.TableToExcel_conversion(fc_table_view, out_xls)

[DanPatterson]

output_folder

fc_name= of+ "\\"+fc+".xls" 

is "of" short for output_folder ?

[DavinWalker2]

Yes the OP has assigned the variable like this

output_folder = of = r" C:\Users\LAP77\Desktop\JR\Veg_Hidro_Final\Excel"

[DanPatterson]

Table To Excel (Conversion)—ArcGIS Pro | Documentation

make sure you specify whether you want an xls or xlsx as well.  There are limitations with xls format

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

In any event, throw in a print statement to make sure you get a valid output filename when you are testing.

And on a different note.  you have a space at the beginning of your paths.

os.path.isdir(" C:\\Temp")  # --- space preceeding path
False

os.path.isdir("C:\\Temp")   # --- no space
True

unless it is a code formatting issue... for future reference

Code formatting ... the Community Version - GeoNet, The Esri Community

[JoelRodriguez95]

Thanks for your time, It's not a code formatting issue because when I print the ListFeatureClasses is all okay, but thank you very much for the Code Formatting for this post!

[Anonymous User]

I just caught that you wanted excel format so I changed the example code.  TableToExcel takes a table view, which is missing from your code.

updated per Blake's note on describe.

import os
import arcpy
from arcpy import env

env.workspace = r" C:\Users\LAP77\Desktop\JR\Veg_Hidro_Final.gdb"
output_folder = r" C:\Users\LAP77\Desktop\JR\Veg_Hidro_Final\Excel"

for fc in arcpy.ListFeatureClasses("*"):
    print(fc)
    out_xls = os.path.join(output_folder, fr'{fc}.xls')
    fc_table_view = arcpy.MakeTableView_management(fc, "tview")
    arcpy.TableToExcel_conversion(fc_table_view, out_xls)

[BlakeTerhune]

Just a couple small notes on ListFeatureClasses().  It returns the feature class names as strings in a list so you don't need to Describe() them. You can also exclude the wild_card parameter as the default will return everything.