EKSPORT DATA ARCGIS KE EXCEL
1. Buka Arcmap.
2. Masukkan SHP yang akan di export datanya kedalam jendela kerja Arcmap Anda.
3. Klik kanan pada SHP kemudian Open Attribute Table
Open Attribute Table
Anda bisa mengexport data sebagian saja, misalnya hanya data tertentu, dengan cara seleksi data yang anda ingin export, namun jika anda ingin export semua datanya, anda tidak perlu seleksi data, secara defaul semua data anda akan di export ke excel
4. Pilih Table To Excel
Pada ArcMap, ada toolbox Table To Excel, anda bisa melihatnya di Coversion Tools > Table To Excel
5. Tentukan SHP dan Lokasi Penyimpanan Serta Nama File Excel Anda Yang Baru
Setelah anda klik Table To Excel, maka akan muncul Pop Up yang memungkinkan anda untuk memberi nama dan menentukan tempat penyimpanan file Excel yang akan anda export. Selanjutnya klik OK dan tunggu sampai selesai.
Summary
Converts a table to a Microsoft Excel file (.xls or .xlsx).
Parameters
DialogPythonLabel | Explanation | Data Type |
Input Table | The table or tables to be converted to an Excel file. | Table View |
Output Excel File (.xls or .xlsx) | The output Excel file. Specify the format of the Excel file using the .xls or .xlsx file extension. | File |
Use field alias as column header (Optional) | Specifies whether input field names or field aliases will be used as the output column names.
| Boolean |
Use domain and subtype description (Optional) | Specifies whether values from subtype fields or fields with a coded value domain will be transferred to the output.
| Boolean |
Name | Explanation | Data Type |
Input_Table [Input_Table,...] | The table or tables to be converted to an Excel file. | Table View |
Output_Excel_File | The output Excel file. Specify the format of the Excel file using the .xls or .xlsx file extension. | File |
Use_field_alias_as_column_header (Optional) | Specifies whether input field names or field aliases will be used as the output column names.
| Boolean |
Use_domain_and_subtype_description (Optional) | Specifies whether values from subtype fields or fields with a coded value domain will be transferred to the output.
| Boolean |
Code sample
The following Python window script demonstrates how to use the TableToExcel function in immediate mode.
import arcpy arcpy.env.workspace = "c:/data" arcpy.conversion.TableToExcel("gdb.gdb/addresses", "addresses.xls")
Converts a table to an Excel workbook.
import arcpy # Set environment settings arcpy.env.workspace = "c:/data" # Set local variables in_table = "gdb.gdb/addresses" out_xls = "addresses.xls" # Run TableToExcel arcpy.conversion.TableToExcel(in_table, out_xls)
Environments
Licensing information
- Basic: Yes
- Standard: Yes
- Advanced: Yes
Related topics
- An overview of the Excel toolset
- Excel To Table
- Find a geoprocessing tool
Feedback on this topic?