从 ArcGIS 10.2里导出属性表,然后用excel打开的方法
[ArcGIS]-Excel中XY点数据生成点Shape文件方法和如何导出shp点坐标
![[ArcGIS]-Excel中XY点数据生成点Shape文件方法和如何导出shp点坐标](https://img.taocdn.com/s3/m/cec0191552d380eb62946db4.png)
[原创] ArcGIS Guide: Excel中XY点数据生成点Shape文件方法Author: Candy Date:2012/8/15 E-mail: @Where: ;1、Excel-XY数据图1 Excel-XY点数据2、ArcGIS-ArcInfo 9.3-GIS软件图2 ArcMap-ArcInfo9.3 软件界面3、将Excel中的点数据(Lat,Lon)转换为Shape文件(point)的方法（1）点击ArcGIS中的按钮，添加数据；选择“Data-XY.xlsx”数据文件，点击Add 按钮添加数据到ArcGIS中。
图3 选择Excel数据文件图4 选择Excel文件中的数据表XY_Data$点击Add添加表格数据到ArcGIS软件中：（2）在Layers图层栏，选择导入的数据表，点击鼠标右键，选择“Data”-“Export…”，将Excel表格保存为*.dbf文件；点击“OK”，导出*dbf格式的文件。
这时在ArcGIS中弹出对话框窗口，询问是否要将“Export_Output.dbf”文件导入到ArcGIS 视图中，选择“yes”（确定）。
（3）将上面生成的*.dbf文件在ArcGIS中显示出来，并导出为Shape文件。
选择Layers栏中的*.dbf文件，点击鼠标右键，选择“Display XY Data…”——选择XY 属性列——选择坐标系统——“OK”。
点击Layers中生成的图层，点击右键，选择“Data”——“Export…”即可导出shape文件。
如下图所示：选择坐标系统(也可由已有的shape文件指定)：选择“Select”——在弹出的坐标系统选择对话框中选择“World”-“WGS 1984”；也可以选择“Import…”——在弹出的窗口中选择已有的Shape文件(要有*.prj文件)。
点击“应用”——“确定”——“OK”。
在显示ArcGIS中显示XY点数据，并注意有一个图层“Export_Ouput Events”产生。
ArcGisdbf读写——挂接Excel到属性表C#
ArcGisdbf读写——挂接Excel到属性表C#ArcMap提供了挂接Excel表格信息到属性表的功能，但是当数据量较⼤到以万计甚⾄⼗万计的时候这个功能就歇菜了，当然，你可以考虑分段挂接。
这个挂接功能只是做了⼀个表关联，属性记录每个字段的信息需要通过“字段计算器”计算过来。
Excel数据写⼊ArcGis属性表功能开发实例中，博主见到太多使⽤UpdateCursor的⽅式，界⾯卡翔，效率感⼈。
优点：插件⽅式开发下不操作ArcObject对象，并且可以使⽤多线程+委托的⽅式使挂接在⼦线程进⾏，进度传回主线程更新UI，挂接速度快且不影响ArcMap的浏览使⽤。
dbf4⽂件格式与解析本篇不讲，可以⾃⾏百度或参考：需要提醒的是⽹上的格式解析说明⽂章都将dbf4编码规则默认为ANSI（中⽂操作系统下是gbk,codepage=936，在⾮英⽂操作系统下，这些⽂章写为ASCII并不严谨）去解析，⽽实际上ArcGis10.2之后版本⽣成的dbf⽂件默认使⽤了utf-8（codepage65001）编码。
这就牵涉到了“FastDBF”在中⽂环境下的bug。
FastDBF读写dbf4⽂件打开dbf⽂件，注意选择字符编码规则var odbf = new DbfFile(Encoding.GetEncoding(rdoGBK.Checked ? 936 : 65001));odbf.Open(dbfPath, FileMode.Open);读取记录数、字段数、长度var header=odbf.Header;int dbfRecordCount=Convert.ToInt32( header.RecordCount);//header.ColumnCount字段数for (int i = 0; i < header.ColumnCount; i++){this.dataGridView2.Rows.Add();//字段名this.dataGridView2[0, i].Value = header[i].Name;//字段类型this.dataGridView2[2, i].Value = header[i].ColumnType.ToString();//字段长度与⼩数位if (header[i].DecimalCount!=0){this.dataGridView2[3, i].Value = header[i].Length.ToString() + "," + header[i].DecimalCount;}elsethis.dataGridView2[3, i].Value = header[i].Length.ToString();}从DataTable中匹配记录挂接，Excel装⼊DataTable可以使⽤epplus，不讲。
在ArcGIS中应用EXCEL表格数据
在ArcGIS中应用EXCEL表格数据48 ArcUser January–March 2004Working With Excel in ArcGISBy Monica Pratt, ArcUser EditorArcGIS works well with Microsoft Excel, the spreadsheet component of Microsoft Office. Data can be shared back and forth between these two programs in a variety of ways. Data that has been created or is being maintained in Excel can be directly accessed by ArcGIS through a con-nection created in ArcCatalog. Joining or relating Excel tables with attribute tables for spatial data provides additional information. Excel can be used as a tool for quickly editing attribute tables.GIS users also take advantage of the extensive table functionality and many formulas that are built into Excel. Finally, existing charts and tables can also be inserted into ArcMap layouts without reformatting.Connect to anExcel Spreadsheet in ArcCatalogArcGIS can directly access data in Excel files. A simple, three-step procedure sets up this connec-tion. First, create an Open Database Connectivity (ODBC data source in Windows, then reformat the data in Excel, and finally connect to the Excel file in ArcCatalog.Create an ODBC Data Source1. In Windows 2000, choose Start > Programs > Administrative Tools > Data Sources. (For other Windows versions, consult Windows online help for creating an ODBC data source.2. In the ODBC Data Source Administrator dialog box, click the User DSN tab and click the Add button.3. Select Microsoft Excel Driver (*.xls and click the Finish button.4. In the ODBC Microsoft Excel Setup dialog box, type a name and description for the data source. Click the Select Workbook button and navigate to the location of the Excel data file and select it.5. Click OK twice to exit the dialog boxes.Reformat Data1. Start Excel and open the desired spreadsheet (.xls file.2. Select the data in the spreadsheet that will be displayed in ArcGIS.3. Choose Insert > Name > Define and type a name for the selected cells. This name will appear in the tables list when the OLE DB Connection is expanded in ArcCatalog or ArcMap.4. Save the file and quit Excel.Connect to the Excel File From ArcCatalog 1. Start ArcCatalog. Expand Database Connec-tions, and click Add OLE DB Connection.2. Select Microsoft OLE DB Provider for ODBC Drivers.3. Click the User Data Source Name button and select the .xls file just named in the previous step from the drop-down list. It may be necessary to use the Refresh button.4. Click the Test Connection button to verify the connection works. A message box should con-firm the connection has succeeded. Click OK. Now the Excel table can be accessed and previewed in ArcCatalog and added directly to amap document in ArcMap by choosing OLE DB Connection.odc.Using Excel WithShapefile Attribute T ablesIn addition to serving as a direct data source, Ex-cel tables can be joined to attribute tables to en-hance the information available for map features. Exporting an attribute file and opening it in Excel makes Excelʼs wide array of formulas, functions, and formatting tools available for quickly editing the table. The file can be saved and rejoined to the spatial file.Enhancing Spatial DataA nonspatial table created in Excel can be joined or related to a layerʼs attribute table if a common field exists or can be created. Use join when the relationship between items in the two tables is one-to-one or many-to-one. Use relate for relationships that are one-to-many and many-to-many. Note that if a relate is used instead of a join, although these new attributes can be que-ried, they cannot be used to set layer properties (i.e., symbolize the data.ArcGIS uses the Microsoft ODBC Text driver for text files. This driver stores a data de-scription of the text fileʼs schema in a file called schema.ini. This file is automatically generated when a text file is opened in ArcGIS and resides in the same directory as the text file.By default, ArcGIS treats files with .txt, .asc, or .csv extensions as comma-delimited text files. Files with a .tab extension are treated as tab-delimited text files. If a .txt or .asc file uses a delimiter other than a comma, the data will not be interpreted correctly. Although the schema.ini file can be manually edited to use a delimiter other than a comma, it is usually less trouble to use a comma-delimited format with the .csv extension for importing tables from Excel.Even though Excel can save files in dBASE (.dbf format, .csv can often be the best choice owing to some idiosyncrasies in the way differ-ent versions of Excel save to the DBF format. When saving data from Excel, numeric fields will be truncated to integers unless the format for that column has been set to include the correct number of decimal places. If a range of cells in the spreadsheet is selected, only that range will be exported.Make sure that the first row in the spreadsheet joined contains field headings. These headings can be no longer than 10 characters; can contain letters and numbers but must begin with a let-ter; and should not incorporate dashes, spaces, or brackets. Replace dashes withunderscores,In the ODBC Data Source Administrator dialog box, click the User DSN tab and clickthe Add button.In the ODBC Microsoft Excel Setup dialog box, type a name and description for the data source. Click the Select Workbook button and navigate to the location of the Excel data fileand select it.Start ArcCatalog. Expand Database Connec-tions and click Add OLE DB Connection.ArcUser January–March 2004 49Hands OnExamine both the Excel table to be joined and the target spatial data to determine thatthey share a common field.Use Join functionality in ArcMap to append the Excel data to the attribute data.The demographic data joined from the Excel table can now be used for analysis and symbolization.and otherwise edit field names so they conform to these guidelines. Each field can contain only one type of data. Consequently, a numeric field should never contain the word NONE or another text string. Use the following procedure to join Excel data with attribute data already in an ArcMap document.1. Examine both the Excel table to be joined and the target spatial data to determine that they share a common field. This field could be a text field such as a county name or a coded numeric field such as a FIPS field (i.e., Federal Information Processing Standards code. Sometimes a com-mon field can be created through concatenating two fields into a new field.2. In Excel, verify that the field (column head-ings conform to naming guidelines required by ArcGIS as described previously. Choose File > Save As and scroll down to CSV (comma-de-limited (*.csv and name and save the file. Click Y es twice to save only the active worksheet and reaffirm the CSV format. Close the file and close Excel.3. Activate or open ArcMap. Click the Add Data button and navigate to the location of the CSV file and select it. ArcMap will display the new table on the Source Tab of the Table of Contents.4. In the Table of Contents, right-click on the spa-tial layer that will be joined with the Excel data and select Join from the context menu.5. In the Join Data dialog box, choose Join At-tributes from a Table. In the first section, click the drop-down box and choose the field from the attribute table that will be used for the join. In the second section, click on the Browse but-ton and navigate to the location of the table to be joined and select it. In the third section, click on the drop-down box and select the field on which the join will be based. Click OK.Right-click on the spatial layer and choose Open Attribute Table from the context menu. The attributes of the t able will be appended to this layerʼs attribute table. Joins can be removedsimply by right-clicking on the spatial layer and choosing Joins > Remove Joins. Joined columns cannot be edited directly, but editing the columns in the original table will change the joined col-umns.Data in individual joined columns canʼt be ed-ited directly. However, editing data in the original table (if it has been added to the map will effect the same changes in the joined columns. To elim-inate this problem, make the join permanent by exporting the data to a new dataset. Right-click on the layer and choose Data > Export Data. Quickly Editing T ablesArcGIS will not allow changes to the type or name of an existing column in an attribute table. However, because attribute tables can be traded back and forth between Excel and ArcGIS with relative ease, attribute tables can be exported out of ArcGIS; brought into Excel; and quickly edited to change data types, aggregate fields, or perform other tasks; then joined with the original table.Note that a shapefileʼs FID and Shape col-umns and a dBASE tableʼs OID column canʼt be deleted. Do not edit these fields. When accessing a tableʼs contents, ArcGIS creates a virtual col-umn, the OID column, to ensure that each record has at least one unique value. Every table needs one column in addition to the Shape and FID or OID columns. Use the following procedure to export an attribute table, edit the table, and join it back to the original attribute file.1. Right-click on the layer containing the table to be edited and choose Open Attribute Table.2. In the table, click on the Options button and choose Export from the menu.3. Navigate to a folder to save the table, name the table, and save it as a DBF file. Donʼt add it back to the map.4. Start Excel and open the DBF file just export-ed. Make the desired changes such as calculating fields or changing field formats.5. Delete all fields that were not modified exceptContinued on page 5050 ArcUser January–March 2004Working With Excel in ArcGISContinued from page 49After selecting the chart or table cells in Excel and activate ArcMap. Choose Insert > Object, click on Create from File, and navi-gate to the location of the Excel file. Although only one object, either a table or chart, can be added per Excel file, multiple objects can be added to a layout if they originate from multiple Excel files.the field that will be used to join the table back to the attribute table.6. Choose File > Save and save as a DBF file. Click Y es to keep out incapable features and con-firm the DBF format. Close Excel.7. Follow steps 3 through 5 in the previous sec-tion to join the modified DBF table to the layerʼs attribute table.Insert Excel T able or Chart Into a Layout ArcGIS can generate formatted tables and a vari-ety of charts. However, the table or chart desired for a layout may already exist as an Excel file. In addition, Excel tables can use more descriptive field headings. Because ArcGIS supports interop-erability, Excel tables and charts can be inserted directly into an ArcGIS layout, eliminating the need to re-create either.Although tables and charts created in Excel can be pasted directly into an ArcMap layout, inserting them has the advantage of maintaining a dynamic link with Excel. With this link, edits made in Excel to a chart or table are reflected in ArcMap. Note that changes made in Excel should always be saved. Unsaved changes may disrupt the linkage between Excel and ArcGIS.1. Open the Excel file containing the desired chart or table data.2. Click on the chart area so that the handles (eight black resizing blocks appear around the chart area, or select the cells in the worksheet page that will be used in the table. Leave the chart or worksheet area selected in Excel, but start ArcMap and choose the Layout View.3. In ArcMap, choose Insert > Object and select Create from File. Click the Browse button and go to the location of the open Excel file and select it.4. In the Insert Object dialog box, check the Link box and click OK.Resize the chart or table appropriately using the frame handles. Tables will come in without a background, but this can be remedied by using the Drawing tools in ArcGIS to create a colored box and placing the box behind the table in the layout. Only one object per Excel file can be inserted in this way. However, objects from multiple Excel files may be inserted in the same layout.ConclusionArcGIS offers flexible methods for working with non-GIS software applications. Take advantage of the interoperability of Excel and ArcGIS tospeed tasks, exploit the sophisticated table func-tionality in Excel, and avoid needless reformat-ting and/or data conversion.在用Excel录入完大量数据后，不可避免地会产生许多错误。
Mapgis里面excel表格的输入与导出步骤和MapGIS做剖面
Mapgis里面excel表格的输入与导出步骤和MapGIS做剖面一、输入1. mapgis主界面→使用服务→报表编辑；2.文件/新建报表文件构造表格/初始表格，构造表格/构造固定表宽，在此可以设置表格的列宽；3.点击菜单中的，拖出表格；拖出自己需要的列数、行数（拖出表格的时候，左下角可以显示x、y=多少）；4.建索引/编辑区块，在已构造好的表格左上方第一个单元格单击鼠标左键拖动到右下角最后一个表格内，左键确认；5.复制ECXEL里的表格数据，建索引/粘贴剪贴内容，然后根据实际情况进行调整；文件/生成MAPGIS数据，将表格转成点，线文件就可以了。
二、输出1.首先建一个Excel表，命名为“属性导出“1.xls”；2.库管理→属性库管理→文件→导出；3.系统弹出“导出内数据”对话框，单击“打开”按钮，打开工程文件“中心城区.MPj”中的“DLTB.WP”文件。
4.配置数据源：单击“数据源”右边的“+”按钮，系统弹出“ODBC数据源管理器”对话框。
5.单击“添加”按钮。
创建新数据源。
6.选择“Driver do Microsoft Excel(*xls)”项，单击“完成”按钮；7. 系统弹出“数据源安装”窗口，数据源名为：111。
单击“选择工作簿”按钮。
找到先前新建的Excel表“1.xls”，并将窗口右边的“只读”属性去掉，单击“确定”按钮。
依次单击“确定”按钮，数据源配置完毕，返回“导出内数据”对话框，在数据源右边的下拉条中，可以看到上一步配置的数据源“111”，选中该数据源。
8. 将导出的表命名为“导出数据”,这时“导出”按钮被激活，单击“导出”按钮，系统提示“导出成功”，数据导出完毕。
1. 首先打开一张等值线图2 对等值线进行编辑结构属性，赋予它一个高程的属性3.。
在矢量化中选中高程自动赋值，利用高程自动赋值赋予等值线属性。
4 所以等值线都赋值以后，保存线文件，打开空间分析中的DTM分析。
如何使用ArcGIS连接Excel表格
如何使用ArcGIS连接Excel表格
在使用ArcGIS做相关分析时候经常需要一些外部的属性数据，如果挨个输入到属性表内是十分不明智的，这时候可以使用ArcGIS的连接功能连接到对应的表格，这里讲解一下具体的操作，希望能够对大家有所帮助。
步骤
第一步：获取Excel表格数据
打开水经注万能地图下载器，框选下载需要的数据，在“新建任务”对话框内选择“POI（兴趣点）”，文件格式选择“txt”，点击“查询”开始查询（图1），导出后使用Excel另存为Excel表格。
图1
第二步：加载数据
打开ArcMap，点击“文件”→“添加数据”→“添加数据”（图2），将准备好的点数据加载进来，打开属性表可以看到只有“name”一个字段（图3）。
图2
图3
第三步：连接表格
在加载进来的图层上点击右键，选择“连接和关联”→“连接”（图4），在弹出的“连接数据”对话框内，第1栏选择“name”，第2栏选择上Excel表，第3栏选择上Excel表内对应的列（图5）。
完成之后再次打开图层属性表，可以看到Excel表内的数据已经加载
图4
图5
图6
结语
到此就完成了使用ArcGIS将现有数据和Excel表连接起来，其实水经注万能地图下载器下载的POI数据直接导出shp格式就和最后的成果一样的丰富，有兴趣的朋友可以使用水经注万能地图下载器和ArcGIS试试。
MapGIS属性数据批量导出到Excel
MapGIS属性数据批量导出到Excel
一、批量导出到Excel步骤在此以2010版.xlsx为例。
需要97-2003
格式的.xls文件可自己另存格式。
第一步新建一个.xlsx文件，路径自选。
举例，在E盘创建【导出属性汇总表.xlsx】文件二、打开MapGIS软件主界面，【库管理】下的【属性库管理】功能
界面，打开【文件】下的【成批导出】功能界面，点击【原始
路径】选择待输出文件所在文件夹，点击【导出文件类型】选
择点、线、面文件。
在【导出文件：】显示框内选择需要导出属
性的文件
三、第三步重点是配置【数据源】。
点击右侧+号，打开【数据源
管理器】，选中第三项（含*.xlsx），然后点击右侧【配置】按钮，打开ODBC安装对话框，在【数据源名】处输入便于识记的名
称，【说明】字段可不填写，然后点击【选择工作簿】，打开对
话框，依次选择上面新建的【导出属性汇总表.xlsx】所在【驱
动器】和【目录】，之后左侧【数据库名】下面的显示框中会显
示出该表格文件，单击选中，文件会出现在上面的框中。
如果
只有一个符合条件的表格文件，则不需要选择。
另外，注意
将右侧【只读】前面的对勾√去掉，然后连续点击确定，直到
回复【成批导出内部数据】对话框。
四、点击【数据源】右侧倒三角▽，选择刚才配置完成的【导出属
性】数据源。
最后，单击【转换】按钮，直到出现“转换完成”
提示。
此时，打开Excel表格文件【导出属性汇总表.xlsx】，下面会显示完成输出的属性子表。
ArcGIS10.2 学习课程——3.数据转换
数据:3.数据转换\mapgis矢量\23.WP
中国信息化高级技术培训中心欢迎你
Page 14
MapGIS格式导出SHP
Mapgis有两种方式 1、输出SHP文件 2、输出Mapinfo格式 输出SHP，点、线基本没有，面转出后， 从表面也没有问题，拓扑检查有问题
Page 4
转换后获得经纬度
添加经纬度字段，使用计算几何工具
中国信息化高级技术培训中心欢迎你
Page 5
如何有经纬度数据获得XY数据
1、度分秒转度 2、生成点文件 3、投影变换（project） 4、添加XY坐标
中国信息化高级技术培训中心欢迎你
数据：3.数据转换\dat和excel转arcgis\经纬度转XY.xls
中国信息化高级技术培训中心欢迎你
1、mapgis->mif->ArcGIS
2、图件和属性数据分别转，要转换的mapGIS文件 的属性用mapGIS软件中的“属性库管理”功能模 块导出成“*.dbf”格式；
Page 21
转换模型
中国信息化高级技术培训中心欢迎你
Page 22
批量转换
中国信息化高级技术培训中心欢迎你
中国信息化高级技术培训中心欢迎你
Page 17
修复几何批量处理
中国信息化高级技术培训中心欢迎你
模型:\3.数据转换\工具箱.tbx\批量修复几何
Page 18
3 MapGIS转ArcGIS格式
转shp时，注记层转成点层，在mapgis中，可增加 注记内容字段，通过点编辑中注释赋为属性，后 转出自动标注，将标注转为注记
mapgis点文件输出点坐标excel文件
mapgis点文件输出点坐标excel文件Mapgis点文件输出点坐标excel文件1、打开mapgis点文件Mapgis6.7主菜单—实用服务—投影变换—文件—打开文件—打开目标点文件。
2、编辑属性结构工具—编辑属性结构—选择文件属性类型—文件—选择目标点文件—属性—点属性结构—确定—出现“编辑属性结构”界面—选第2行—字段名称—输“点号”—按回车键—字段类型—字符串—按回车键—字段长度—20—按回车键—进入第3行—X—双精度型—字段长度—12—小数位数—3—按回车键—进入第4行—Y—双精度型—字段长度—12—小数位数—3—按回车键—进入第5行—OK。
3、点位置转换属性工具—点位置转换属性—进入“点位置或注释生成属性”界面—图元文件—选择文件—选目标点文件—确定—点位置X—下拉菜单选X（最好不要选Y）—点位置Y—下拉菜单选Y（最好不要选X）—转换—保存—确定。
4、属性生成文本文件工具—属性生成文本文件—进入“图元属性转换生成文本文件”界面—图元文件—选择文件—选点文件—确定—生成文件—另存为—××—保存类型—文本文件（*.txt）—保存—转换—确定。
5、文本文件转excel文件打开excel2003主界面—文件—打开—文件类型—文本文件—查找范围—××盘××文本文件—打开—选“分隔符号”—下一步—空格打钩—完成——文件—另存为（不选择保存，选择另存为）—保存类型—excel工作簿—起文件名—××—保存。
6、调整excel表数据根据图形比例尺调整excel表点数据的放大倍数，得实际坐标，为传输至手持GPS作准备（如单纯是文本文件转excel文件，此处可不要）—删除原有点数据—另存为（不选择保存，选择另存为）—保存类型—excel工作簿—起文件名—××—保存。
打开另存的excel表—数据—排序—出现“排序”框—主要关键字—下拉菜单选ID—升序—次要关键字—下拉菜单选x—升序—第三关键字—下拉菜单选y—升序—选项—出现“排序选项”框—方向—按列排序—确定—确定—保存。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
从 ArcGIS里导出属性表
第一种方法：
第一步：在Arctoolbox 里右键点击，选择“New toolbox”, 在新建立的“Toolbox”上点右键，然后点“Add”——“ Tool”—— Data Interoperability Tools
第二步：双击Quick export，然后再“input layer”里选择要导出的数据表所在的层。
在“output dataset”点击右边的“…”，然后在”Format”右边点击“…”选择要导出的数据类型，在“Dataset”里选择事先建好的数据文件（在导出数据前先建一个数据库，类型和要导出的类型一致）。
最后点击“OK”就可以了。
第二种方法：导出dbf表
ArcCatalog 中找到该属性表所在的位置，右键单击，点击“export”，然后点击“To Geodtabase （single）”。
在“output Location”中选择数据库名称（事先建好数据库），输入数据表名称，点击“OK”。