topic Re: When will Table to Table support .xlsx files? in Data Management Questions

When will Table to Table support .xlsx files?

DanielSheehan — Thu, 27 Jan 2011 20:24:54 GMT

Is there any plan for exporting tables in ArcCatalog from .xlsx files? .xls still work fine. It just slows everything down and not sure how to avoid doing it manually by integrating it with my Python scripts. I wish Microsoft didn't get rid of save to .dbf in Excel.

PS I know GIS data should be in databases not in spreadsheets but so much source data comes in excel.

Re: When will Table to Table support .xlsx files?

MaximeDemers — Fri, 22 Apr 2016 19:42:44 GMT

It's a shame that in 2016 ArcGIS cannot export a table to xlsx dirrectly!

Re: When will Table to Table support .xlsx files?

DarrenWiens2 — Sun, 12 Dec 2021 05:46:17 GMT

Not sure if this is the type of answer you're looking for, but since you're already using Python scripts...

XlsxWriter 0.8.5 : Python Package Index

>>> import xlsxwriter # import library
... fc = 'points' # feature class/layer
... workbook = xlsxwriter.Workbook('C:\junk\my_new_workbook.xlsx') # new workbook
... worksheet = workbook.add_worksheet() # create worksheet
... fieldnames = [i.name for i in arcpy.ListFields(fc)] # list fields in fc
... for field,fieldname in enumerate(fieldnames): 
...    worksheet.write(0,field,fieldname) # write field names to xlsx
... with arcpy.da.SearchCursor(fc,'*') as cursor: # loop through features
...    for row,row_val in enumerate(cursor): # loop through rows
...        for col,col_val in enumerate(row_val): # loop through columns
...            try:
...                worksheet.write(row+1,col,col_val) # if text or number, write value
...            except:
...                worksheet.write(row+1,col,repr(col_val)) # if something else (like a shape) write the representation
... workbook.close() # close the workbook

edit: just realized the original post was made 5 years ago, so it's possible that xlsxwriter didn't exist then, but it does now!

Re: When will Table to Table support .xlsx files?

DanPatterson_Retired — Fri, 22 Apr 2016 21:35:39 GMT

I think that it is the Friday afternoon migratory ghosts Darren...this isn't only only old post to come through

Re: When will Table to Table support .xlsx files?

curtvprice — Sat, 23 Apr 2016 02:24:37 GMT

Also, Esri has shipped tools to read and write Excel files. (They use Python modules that are shipped with ArcGIS.)

Here's the current story on Excel support in the help.

Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS for Desktop

Re: When will Table to Table support .xlsx files?

DarrenWiens2 — Sat, 23 Apr 2016 15:16:33 GMT

But they only write to xls, not xlsx, as far as I know. Is there a method to write to xlsx out of the box?

Re: When will Table to Table support .xlsx files?

DanPatterson_Retired — Sat, 23 Apr 2016 15:52:43 GMT

not out of the box, but they do exist

XlsxWriter 0.8.5 : Python Package Index

openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files — openpyxl 2.3.5 documentation

plus there are a couple of branches on github

Re: When will Table to Table support .xlsx files?

DarrenWiens2 — Sat, 23 Apr 2016 16:55:10 GMT

Okay, we're starting to circle (see my previous example). Meeting adjourned.

Re: When will Table to Table support .xlsx files?

DanPatterson_Retired — Sat, 23 Apr 2016 16:57:07 GMT

grief... great minds think ... then there are the rest of us, time to change the bifocals

Re: When will Table to Table support .xlsx files?

AdrianWelsh — Sun, 24 Apr 2016 01:55:55 GMT

Dan, this is interesting. How often do these 'ghosts' practice their migrating? Is this why we see old stuff get bumped a lot?

Re: When will Table to Table support .xlsx files?

DanPatterson_Retired — Sun, 24 Apr 2016 02:16:45 GMT

Cleanup is done by us moderators during downtime ... which varies according to traffic and who is awake.

Old threads can get bumped when the poster makes an edit, a moderator changes a question to a discussion or when someone marks a question answered, or... when someone answers an old question that gets bumped then realizes the thread is many years old.

This gives others the opportunity to recommend options that someone else already posted since the order of threads in the mailbox is not in chronological order...ergo my response to Darren's missive.

Pretty well sums it up... On the upside, the original poster's email will be flooded with new traffic for something long forgotten...

PS moving to Managing Data since the generic GIS category is too generic

Re: When will Table to Table support .xlsx files?

AdrianWelsh — Sun, 24 Apr 2016 22:34:29 GMT

This makes sense. So it's safe to say that these 'ghosts' are just the moderators moderating? I am guessing there is no automatic migration that is making old threads get bumped?

Re: When will Table to Table support .xlsx files?

DanPatterson_Retired — Sun, 24 Apr 2016 22:55:48 GMT

not automatically... just automagically

Re: When will Table to Table support .xlsx files?

curtvprice — Thu, 28 Apr 2016 03:26:05 GMT

I try to avoid .xlsx for data unless I really need functionality like big worksheets. If your datasets are that big, you probably should be using a database anyway!

Re: When will Table to Table support .xlsx files?

BruceHarold — Thu, 28 Apr 2016 18:21:02 GMT

Data Interoperability extension will write XLSX.

Of course it has a cost.