Summary
Converts a table to a Microsoft Excel file.
Usage
Table To Excel is able to convert only to Microsoft Excel 5.0/95 Workbook (.xls) format.
Syntax
TableToExcel_conversion (Input_Table, Output_Excel_File, {Use_field_alias_as_column_header}, {Use_domain_and_subtype_description})
Parameter | Explanation | Data Type |
Input_Table | The table to be converted to Microsoft Excel format. | Table View |
Output_Excel_File | The output Microsoft Excel file. | File |
Use_field_alias_as_column_header (Optional) | How column names in the output are determined.
| Boolean |
Use_domain_and_subtype_description (Optional) | Controls how values from subtype fields or fields with a coded value domain are transferred to the output.
| Boolean |
Code sample
TableToExcel example (Python window)
The following Python window script demonstrates how to use the TableToExcel function in immediate mode.
import arcpy
arcpy.env.workspace = "c:/data"
arcpy.TableToExcel_conversion("gdb.gdb/addresses", "addresses.xls")
TableToExcel example 2 (stand-alone script)
Converts a table to a Microsoft Excel workbook.
# Name: TableToExcel_2.py
import arcpy
# Set environment settings
arcpy.env.workspace = "c:/data"
# Set local variables
in_table = "gdb.gdb/addresses"
out_xls = "addresses.xls"
# Execute TableToExcel
arcpy.TableToExcel_conversion(in_table, out_xls)
Environments
Licensing information
- ArcGIS Desktop Basic: Yes
- ArcGIS Desktop Standard: Yes
- ArcGIS Desktop Advanced: Yes