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 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")

Find more posts tagged with

Accepted answers

JoelRodriguez95

Thanks for your time, and I'm sorry for not verified the spaces.

import os
import arcpy
from arcpy import env

env.workspace = r"C:\data.gdb"
output_folder = r"C:\output"

for fc in arcpy.ListFeatureClasses("*"):
    out_xls = os.path.join(output_folder, r'{}.xls'.format(fc))
    env.overwriteOutput = True
    fc_path = os.path.join(env.workspace, fc)
    fc_table_view = arcpy.MakeTableView_management(fc_path, "tview")
    arcpy.TableToExcel_conversion(fc_table_view, out_xls)

danretired

spaces in the path.... isn't a path if it is the first character especially

raw encoding won't help for that either

Anonymous User

for the already exists error, you can del it at the end of the iteration or you can add

env.overwriteOutput = True

under the imports so it overwrites the outputs.

All comments

JoelRodriguez95

Thanks for your time, and I'm sorry for not verified the spaces.

import os
import arcpy
from arcpy import env

env.workspace = r"C:\data.gdb"
output_folder = r"C:\output"

for fc in arcpy.ListFeatureClasses("*"):
    out_xls = os.path.join(output_folder, r'{}.xls'.format(fc))
    env.overwriteOutput = True
    fc_path = os.path.join(env.workspace, fc)
    fc_table_view = arcpy.MakeTableView_management(fc_path, "tview")
    arcpy.TableToExcel_conversion(fc_table_view, out_xls)

danretired

spaces in the path.... isn't a path if it is the first character especially

raw encoding won't help for that either

JoelRodriguez95

sorry for the inconvenience , but it throws me error:

>>> import os
... import arcpy
... from arcpy import env
... 
... env.workspace = r" C:\Users\LAP77\JR\Veg_Hidro_Final\Veg_Hidro_Final.gdb"
... output_folder = r" C:\Users\LAP77\JR\Veg_Hidro_Final\Excel"
... 
... for fc in arcpy.ListFeatureClasses("*"):
...     print(fc)
...     out_xls = os.path.join(output_folder, r'{}.xls'.format(fc))
...     print(out_xls)
...     fc_table_view = arcpy.MakeTableView_management(fc,"tview")
...     arcpy.TableToExcel_conversion(fc_table_view, out_xls)
...     
 C:\Users\LAP77\JR\Veg_Hidro_Final\Excel\Veg_Hidro_Final.xls
Runtime error  Traceback (most recent call last):   File "<string>", line 12, in <module>   File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\management.py", line 6966, in MakeTableView     raise e ExecuteError: ERROR 000732: Input Table: Dataset Veg_Hidro_Final does not exist or is not supported

these are the feature classes in the gdb:

and this a part of table's Veg_Hidro_Final

Anonymous User

ok could a difference between python 2 and 3. Change it to:

out_xls = os.path.join(output_folder, r'{}.xls'.format(fc))

JoelRodriguez95

Thanks for yout time! I tried with this script but I get the following error:

Parsing error SyntaxError: invalid syntax (line 10)

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)

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!

danretired

try printing the "fc" name as well to make sure it exists and that it is a geodatabase table.

You just printed the output xls name.

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).

blake.terhune

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.

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)

danretired

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

DavinWalker2

Yes the OP has assigned the variable like this

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

danretired

output_folder

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

is "of" short for output_folder ?

DavinWalker2

What error are you getting when you run the 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.