Generate Excel From Geodatabase (Topographic Production Tools)

サマリー

Creates a Microsoft Excel file (.xls or .xlsx) from the contents of a geodatabase.

使用法

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.

ラベル	説明	データタイプ
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

arcpy.topographic.GenerateExcelFromGeodatabase(in_geodatabase, out_excel_file)

名前	説明	データタイプ
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

コードのサンプル

GenerateExcelFromGeodatabase example (Python window)

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

# 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'

# Run Generate Excel From Geodatabase
arcpy.topographic.GenerateExcelFromGeodatabase(in_geodatabase, out_excel_file)

環境

このツールは、ジオプロセシング環境を一切使用しません。

ライセンス情報

Basic: No
Standard: Requires Topographic Mapping
Advanced: Requires Topographic Mapping

Generate Excel From Geodatabase (Topographic Production Tools)

サマリー

使用法

パラメーター

環境

ライセンス情報

関連トピック