153 reputation
11
bio website linkedin.com/in/kristengrady
location New York, NY
age
visits member for 3 years
seen Jul 2 at 18:00

I'm a GIS Specialist at a NYC City Agency with a previous life in Academia. I've been using Python for a few years now, but still have a lot to learn. I couldn't make the progress I do without this site.


Jun
12
revised How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
added 1 character in body
Jun
11
revised How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
added 1134 characters in body
Jun
11
comment How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
Wow, I have to admit that I looked at the code for this tool and couldn't quite figure out how to do the specific thing I needed to do with it (loop through a bunch of query layer tables in an MXD and export them all at once), so I ended up writing code using xlsxwriter, which I felt I understood better (see answers/posts below). What I did not realize is that when you download this package it comes with a toolbox for ArcTooblox (!!), which I find pretty damn useful, especially if I use batch to run multiple tables at once.
Jun
11
accepted How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
Jun
11
comment How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
... cont'd. I was also getting some other errors regarding naming, such as "TypeError: argument of type 'TableView' is not iterable" and "TypeError: 'TableView' object is not subscriptable," all sort of making me think I just simply had to make those table views permanent...
Jun
11
comment How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
Another fantastic "answer"! I'm going line by line myself and have a bit to go, but something I am struggling with is not needing to make the table views permanent. Something strange happens with naming when I don't use CopyRows; it tries to name my Excel doc: "KGRADY".%Agency_Export_DFTA_2_11_1_2". When I use CopyRows, it gets it right and reduces the MXD table view name from "CC_Export_Agency_DFTA" to simply "DFTA." Any ideas? (And actually that's involving some code I added later on. If it would help to see it, I can post it)...
Jun
10
answered How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
Jun
8
comment How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
Wow, this is fantastic. Thank you so much. I'm going to take a good look at my data and at both of these scripts and then determine what's best to do. I'll report back!
Jun
5
awarded  Critic
Jun
5
comment How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
Ah, yes. I should have noted that I did find that tool earlier and have taken a look at it. I may end up using that after all. I'll update my question to reflect that find.
Jun
5
comment How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
@GeoJohn Yes, I do. I added it to the lib folder.
Jun
5
asked How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
Apr
6
asked Snapping leaves small gap between features in ArcGIS for Desktop?
Mar
19
awarded  Popular Question
Jan
9
accepted Rule -torque-frame-count not allowed for Map
Nov
27
awarded  Popular Question
Nov
17
asked Rule -torque-frame-count not allowed for Map
Sep
24
awarded  Autobiographer
Jul
2
awarded  Curious
Jan
10
comment Arcpy ListLayers function returns only the first sub layer in a group layer (as opposed to the group layer AND all sub layers of that group)
Works! Thanks a lot. I started out with an IF/ELIF statement. I'm not sure why I switched to IFs with breaks. Still learning :)