How to export a feature layer attribute table to a specific worksheet of an already existing Excel workbook?


The Table To Excel (Conversion) tool which was new at ArcGIS 10.2 has the usage below.

TableToExcel_conversion (Input_Table, Output_Excel_File, {Use_field_alias_as_column_header}, {Use_domain_and_subtype_description})

As you can see it writes to an Excel file and does not provide an option to specify a worksheet within an Excel file as output.

Consequently, to try and do this at present I would look at using a non-Esri Python module such as XlsxWriter with an arcpy.da.SearchCursor.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.