topic Re: Export layers of a gdb as excel table in Python Questions

Export layers of a gdb as excel table

JoelRodriguez95 — Wed, 17 Feb 2021 01:06:07 GMT

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

Re: Export layers of a gdb as excel table

DavinWalker2 — Wed, 17 Feb 2021 01:15:26 GMT

What error are you getting when you run the script?

Re: Export layers of a gdb as excel table

DanPatterson — Wed, 17 Feb 2021 02:24:01 GMT

output_folder

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

is "of" short for output_folder ?

Re: Export layers of a gdb as excel table

DavinWalker2 — Wed, 17 Feb 2021 02:31:36 GMT

Yes the OP has assigned the variable like this

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

Re: Export layers of a gdb as excel table

DanPatterson — Wed, 17 Feb 2021 02:52:01 GMT

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

Re: Export layers of a gdb as excel table

Anonymous User — Wed, 17 Feb 2021 14:34:04 GMT

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)

Re: Export layers of a gdb as excel table

BlakeTerhune — Wed, 17 Feb 2021 14:19:16 GMT

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.

Re: Export layers of a gdb as excel table

JoelRodriguez95 — Wed, 17 Feb 2021 16:15:40 GMT

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

Re: Export layers of a gdb as excel table

DanPatterson — Wed, 17 Feb 2021 16:26:17 GMT

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.

Re: Export layers of a gdb as excel table

JoelRodriguez95 — Wed, 17 Feb 2021 16:27:03 GMT

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!

Re: Export layers of a gdb as excel table

Anonymous User — Wed, 17 Feb 2021 16:31:21 GMT

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)

Re: Export layers of a gdb as excel table

JoelRodriguez95 — Wed, 17 Feb 2021 16:46:07 GMT

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

Parsing error SyntaxError: invalid syntax (line 10)

Re: Export layers of a gdb as excel table

Anonymous User — Wed, 17 Feb 2021 16:54:20 GMT

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

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

Re: Export layers of a gdb as excel table

JoelRodriguez95 — Wed, 17 Feb 2021 17:20:48 GMT

sorry for the inconvenience :(, but it throws me error:

these are the feature classes in the gdb:

and this a part of table's Veg_Hidro_Final

Re: Export layers of a gdb as excel table

Anonymous User — Wed, 17 Feb 2021 17:33:40 GMT

Try with the full path to the fc:

... out_xls = os.path.join(output_folder, r'{}.xls'.format(fc)) print(out_xls) fc_path = os.path.join(env.workspace, fc) fc_table_view = arcpy.MakeTableView_management(fc_path, "tview")

Re: Export layers of a gdb as excel table

DanPatterson — Wed, 17 Feb 2021 17:37:36 GMT

print the featureclass name and the out_xls name ... ie print(fc, out_xls)

Re: Export layers of a gdb as excel table

JoelRodriguez95 — Wed, 17 Feb 2021 17:57:38 GMT

nothing 😞

>>> 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("1::",fc) ... out_xls = os.path.join(output_folder, r'{}.xls'.format(fc)) ... print("2::",out_xls) ... print("3::",fc, out_xls) ... 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) ... ('1::', u'Veg_Hidro_Final') ('2::', ' C:\\Users\\LAP77\\JR\\Veg_Hidro_Final\\Excel\\Veg_Hidro_Final.xls') ('3::', u'Veg_Hidro_Final', ' C:\\Users\\LAP77\\JR\\Veg_Hidro_Final\\Excel\\Veg_Hidro_Final.xls') Runtime error Traceback (most recent call last): File "<string>", line 15, in <module> File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\conversion.py", line 81, in TableToExcel raise e ExecuteError: Traceback (most recent call last): File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\TableToExcel.py", line 222, in <module> arcpy.GetParameter(3)) File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Scripts\TableToExcel.py", line 216, in table_to_excel workbook.save(output) File "C:\Python27\ArcGIS10.3\lib\site-packages\xlwt\Workbook.py", line 662, in save doc.save(filename, self.get_biff_data()) File "C:\Python27\ArcGIS10.3\lib\site-packages\xlwt\CompoundDoc.py", line 261, in save f = open(file_name_or_filelike_obj, 'w+b') IOError: [Errno 22] invalid mode ('w+b') or filename: u' C:\\Users\\LAP77\\JR\\Veg_Hidro_Final\\Excel\\Veg_Hidro_Final.xls' Failed to execute (TableToExcel).

and when I use the script again, this is the error.

Runtime error Traceback (most recent call last): File "<string>", line 14, in <module> File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\management.py", line 6966, in MakeTableView raise e ExecuteError: ERROR 000725: Table Name: Dataset tview already exists.

Re: Export layers of a gdb as excel table

JoelRodriguez95 — Wed, 17 Feb 2021 18:00:05 GMT

I did it in my last answer, thanks for your time

Re: Export layers of a gdb as excel table

Anonymous User — Wed, 17 Feb 2021 18:02:00 GMT

Ok, Like Dan said earlier you have spaces in your paths. r" C:...".

This error is saying it cant find <space>C:/... in your output. remove the spaces and try again.

Re: Export layers of a gdb as excel table

Anonymous User — Wed, 17 Feb 2021 18:06:28 GMT

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.