Researching to see if there is a way to use Python to export multiple tables in a File Geodatabase to a single Excel file. I would like for each sheet name to have the same name as the table. My current situation is that I ran a Python script to take all the domains a GDB and create a table within the GDB. The article referenced from: https://community.esri.com/thread/163889 def main ( ) : import arcpy , os gdb = r "Z:\GIS_Projects\zUpdatesBrian\Scripts\ListDomains\ListDomains.gdb" arcpy . env . overwriteOutput = True for dom in arcpy . da . ListDomains ( gdb ) : if dom . domainType == 'CodedValue' : arcpy . DomainToTable_management ( in_workspace = gdb , domain_name = dom . name , out_table = os . path . join ( gdb , dom . name ) , code_field = "item" , description_field = "descrip" , configuration_keyword = "" ) print " - domain '{0}' of type '{1}' exported to table" . format ( dom . name , dom . domainType ) else : print " - domain '{0}' of type '{1}' skipped" . format ( dom . name , dom . domainType ) if __name__ == '__main__' : main ( )

Ha.... Got it.... Notice below where I place the writer variable: outside the for loop. What was happening is the target xls would get re-initialized each time through the loop. Now that I set it up outside the loop, it runs like a champ! Fun stuff! And I'm getting paid for it! import pandas as pd import arcpy from arcpy import env fields = [ 'TaxingEntity' , 'ProjectID' ] targetXL = r 'J:\RDA\ToBlake.xls' ##### # arcpy . env . workspace = r 'J:\RDA\Temp2.gdb' tables = arcpy . ListTables ( ) writer = pd . ExcelWriter ( targetXL ) for table in tables : if table == 'AllTables_5_16' : pass elif table == 'NeedTaxEntRecords' : pass elif table == 'BlakesTaxinEntities' : pass else : inTable = table tableArray = arcpy . da . TableToNumPyArray ( inTable , fields ) df = pd . DataFrame ( tableArray ) df . to_excel ( writer , table ) del tableArray del df writer . save ( ) Sorry to hi-jack your thread Brian M, but here you go!

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 multiple tables in GDB to Excel with a new sheet for each table

Brian_McLeer

Researching to see if there is a way to use Python to export multiple tables in a File Geodatabase to a single Excel file. I would like for each sheet name to have the same name as the table.

My current situation is that I ran a Python script to take all the domains a GDB and create a table within the GDB.

The article referenced from:

https://community.esri.com/thread/163889

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> 
 <SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os 
 gdb <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Z:\GIS_Projects\zUpdatesBrian\Scripts\ListDomains\ListDomains.gdb"</SPAN> 
 arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN> 
 
 <SPAN class="keyword token">for</SPAN> dom <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>ListDomains<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> 
 <SPAN class="keyword token">if</SPAN> dom<SPAN class="punctuation token">.</SPAN>domainType <SPAN class="operator token">==</SPAN> <SPAN class="string token">'CodedValue'</SPAN><SPAN class="punctuation token">:</SPAN> 
 arcpy<SPAN class="punctuation token">.</SPAN>DomainToTable_management<SPAN class="punctuation token">(</SPAN>in_workspace<SPAN class="operator token">=</SPAN>gdb<SPAN class="punctuation token">,</SPAN> 
 domain_name<SPAN class="operator token">=</SPAN>dom<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> 
 out_table<SPAN class="operator token">=</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">,</SPAN> dom<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> 
 code_field<SPAN class="operator token">=</SPAN><SPAN class="string token">"item"</SPAN><SPAN class="punctuation token">,</SPAN> 
 description_field<SPAN class="operator token">=</SPAN><SPAN class="string token">"descrip"</SPAN><SPAN class="punctuation token">,</SPAN> 
 configuration_keyword<SPAN class="operator token">=</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN> 
 
 <SPAN class="keyword token">print</SPAN> <SPAN class="string token">" - domain '{0}' of type '{1}' exported to table"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>dom<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> dom<SPAN class="punctuation token">.</SPAN>domainType<SPAN class="punctuation token">)</SPAN> 
 <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> 
 <SPAN class="keyword token">print</SPAN> <SPAN class="string token">" - domain '{0}' of type '{1}' skipped"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>dom<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> dom<SPAN class="punctuation token">.</SPAN>domainType<SPAN class="punctuation token">)</SPAN> 
 
<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN> 
 main<SPAN class="punctuation token">(</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>

Najděte více příspěvků označených jako

Accepted answers

All comments

JoeBorgione

I'm in the same boat: I have multiple tables in a fgdb and would like to export them to a workbook as individual worksheets. Just moments ago, I installed the xlsxwriter module as a package in ArcGIS Pro. That's the easy part. Now I'm working on figuring it out. See: Getting Started with XlsxWriter — XlsxWriter Documentation ( I just create my Hello.xls...)

Hey Dan, Joshua or Curtis- ever work with xlsxwriter?

yes ... but not tonight

JoeBorgione

JoshuaBixby

Now that Pandas comes bundled with ArcGIS, just use TableToNumPyArray—Data Access module | ArcGIS Desktop and pandas.DataFrame.to_excel — pandas 0.23.0 documentation.

JoeBorgione

Thanks. I'll take a look in the morning.

JoeBorgione

Getting pretty close, but not quite there. For some reason, I can only get pandas to write one of my tables out to the target excel spreadhheet, and that depends on where I put writer.save() function:

<SPAN class="keyword token">import</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TaxingEntity'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectID'</SPAN><SPAN class="punctuation token">]</SPAN>
targetXL <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'J:\RDA\junk.xls'</SPAN>
<SPAN class="comment token">#</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'J:\RDA\Temp2.gdb'</SPAN>
<SPAN class="comment token">#tables = arcpy.ListTables()</SPAN>
tables <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Project101'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Project102'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Project103'</SPAN> <SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> table <SPAN class="keyword token">in</SPAN> tables<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> table <SPAN class="operator token">==</SPAN> <SPAN class="string token">'AllTables_5_16'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">pass</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> table <SPAN class="operator token">==</SPAN> <SPAN class="string token">'NeedTaxEntRecords'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">pass</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> table <SPAN class="operator token">==</SPAN> <SPAN class="string token">'BlakesTaxinEntities'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">pass</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> table
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tableArray <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>TableToNumPyArray<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>tableArray<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; writer <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>ExcelWriter<SPAN class="punctuation token">(</SPAN>targetXL<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; df <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>data<SPAN class="operator token">=</SPAN>tableArray<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; df<SPAN class="punctuation token">.</SPAN>to_excel<SPAN class="punctuation token">(</SPAN>targetXL<SPAN class="punctuation token">,</SPAN>table<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; writer<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> df<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In this example of my code, I'm only working with 3 of the 100+ tables which is why line 8 is commented and line 9 creates a list of table names. The problem child seems to be line 25 writer.save(): at it's current location inside the for loop, I only get Project101 written to the target, and I get an error:

IndexError: list index out of range

If I comment it out or put it outside the for loop, I don't get any errors, but I only get Project 103 to get written to the target.

Perhaps a second (or third) set of eyes might see what the issue could be?

Joshua Bixby‌

Dan Patterson‌

JoshuaBixby

My guess is this line is messing it up:

df<SPAN class="punctuation token">.</SPAN>to_excel<SPAN class="punctuation token">(</SPAN>targetXL<SPAN class="punctuation token">,</SPAN>table<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Instead of passing the XLS file path, try passing the writer itself.

JoeBorgione

Following pandas.DataFrame.to_excel — pandas 0.23.0 documentation , it shows:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> writer <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>ExcelWriter<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'output.xlsx'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> df1<SPAN class="punctuation token">.</SPAN>to_excel<SPAN class="punctuation token">(</SPAN>writer<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Sheet1'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> df2<SPAN class="punctuation token">.</SPAN>to_excel<SPAN class="punctuation token">(</SPAN>writer<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Sheet2'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> writer<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

However, when I use 'writer' as shown in lines 1 & 2 (line 24 in my script) the target excel work book does get created at all. However, when I use targetXL , it does get created,with only one sheet. Weird....

When I take the process out of the loop, and only work with 1 table it works as you and the documentation suggests:

<SPAN class="keyword token">import</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TaxingEntity'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectID'</SPAN><SPAN class="punctuation token">]</SPAN>
targetXL <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'J:\RDA\junk.xls'</SPAN>
<SPAN class="comment token">#</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'J:\RDA\Temp2.gdb'</SPAN>

table <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Project101'</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># just one, not a list now....</SPAN>

inTable <SPAN class="operator token">=</SPAN> table
tableArray <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>TableToNumPyArray<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN>
writer <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>ExcelWriter<SPAN class="punctuation token">(</SPAN>targetXL<SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>tableArray<SPAN class="punctuation token">)</SPAN>
df<SPAN class="punctuation token">.</SPAN>to_excel<SPAN class="punctuation token">(</SPAN>writer<SPAN class="punctuation token">,</SPAN>table<SPAN class="punctuation token">)</SPAN>
writer<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</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>

When I put print() functions in along the way, I can see each array, and each subsequent dataframe while in the original loop; again weird. I'll keep hacking.....

JoeBorgione

Ha.... Got it.... Notice below where I place the writer variable: outside the for loop. What was happening is the target xls would get re-initialized each time through the loop. Now that I set it up outside the loop, it runs like a champ! Fun stuff! And I'm getting paid for it!

<SPAN class="keyword token">import</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TaxingEntity'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ProjectID'</SPAN><SPAN class="punctuation token">]</SPAN>
targetXL <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'J:\RDA\ToBlake.xls'</SPAN> <SPAN class="comment token">##### <- set up the target outside the loop</SPAN>
<SPAN class="comment token">#</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'J:\RDA\Temp2.gdb'</SPAN>
tables <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListTables<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
writer <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>ExcelWriter<SPAN class="punctuation token">(</SPAN>targetXL<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> table <SPAN class="keyword token">in</SPAN> tables<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> table <SPAN class="operator token">==</SPAN> <SPAN class="string token">'AllTables_5_16'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">pass</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> table <SPAN class="operator token">==</SPAN> <SPAN class="string token">'NeedTaxEntRecords'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">pass</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> table <SPAN class="operator token">==</SPAN> <SPAN class="string token">'BlakesTaxinEntities'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">pass</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> table
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tableArray <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>TableToNumPyArray<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; df <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>tableArray<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; df<SPAN class="punctuation token">.</SPAN>to_excel<SPAN class="punctuation token">(</SPAN>writer<SPAN class="punctuation token">,</SPAN>table<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> tableArray
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> df
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; writer<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Sorry to hi-jack your thread Brian M‌, but here you go!

Brian_McLeer

That really helps, thank you very much, Joe!

mdavenport

Hi @JoeBorgione ! I hope you can help me. I'm trying to get multiple tables to one xlsx file. It worked once, but the tab names were a bit off. I retried and now my code is not working but I'm not getting an error; it's just not writing the file. Any guesses on how to correct? I'm new to ArcPy so trying my best! My ultimate goal is to have many tables, not just three, go into one large excel workbook. I thought I'd start there though. I appreciate any feedback!

import pandas as pd
import arcpy
from arcpy import env
fields = ['FORESTNAME', 'SUM_Acres_1']
targetXL = r'D:/Projects/testtablemerge.xlsx'
arcpy.env.workspace = "D:/Projects/Workflow_python.gdb"
tables = arcpy.ListTables()
writer = pd.ExcelWriter(targetXL)
for table in tables:
    if table == 'dmg_NF_intersect_SummarizeAcres':
        pass
    elif table == 'dmg_NF_MPB_all':
        pass
    elif table == 'dmg_NF_MPB_5N':
        pass
    else:
        inTable = table
        tableArray = arcpy.da.TableToNumPyArray(inTable,fields)
        df = pd.DataFrame(tableArray)
        df.to_excel(writer,table)
        del tableArray
        del df
        writer.save()

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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