Etiqueta | Explicación | Tipo de datos |
Input Geodatabase | The geodatabase that will be used to create the Excel spreadsheet. | Workspace |
Output Excel File
| The Excel file that will be created from the geodatabase. | File |
Resumen
Creates a Microsoft Excel file (.xls or .xlsx) from the contents of a geodatabase.
Uso
This tool will create an Excel spreadsheet that defines the schema of a topographic production database and can be used in the Generate Geodatabase From Excel tool.
The Excel file that is generated consists of multiple worksheets based on the components of the geodatabase. The individual worksheets in the file contain the spatial reference, datasets, object classes, subtypes, fields, domains, and metadata to be included in the geodatabase.
Parámetros
arcpy.topographic.GenerateExcelFromGeodatabase(in_geodatabase, out_excel_file)
Nombre | Explicación | Tipo de datos |
in_geodatabase | The geodatabase that will be used to create the Excel spreadsheet. | Workspace |
out_excel_file | The Excel file that will be created from the geodatabase. | File |
Muestra de código
The following Python window script demonstrates how to use the GenerateExcelFromGeodatabase function.
# Name: GenerateExcelFromGeodatabase_sample.py
# Description: Uses the contents of a geodatabase to create a Microsoft Excel file (.xls or .xlsx).
# Import System Modules
import arcpy
# Check Out Extensions
arcpy.CheckOutExtension('Foundation')
# Setting the environment
arcpy.env.overwriteOutput = True
# Setting Local Variables
in_geodatabase = r'C:\Data\GDB\MGCP_TRD_4_6.gdb'
out_excel_file = r'C:\Data\Excel\MGCP_TRD_4_6.xls'
# Execute Generate Excel From Geodatabase
arcpy.topographic.GenerateExcelFromGeodatabase(in_geodatabase, out_excel_file)
# Check In Extensions
arcpy.CheckInExtension('Foundation')
Entornos
Esta herramienta no utiliza ningún entorno de geoprocesamiento.
Información de licenciamiento
- Basic: No
- Standard: Requiere Production Mapping
- Advanced: Requiere Production Mapping