However, you will not be able to edit the table or export records to an Excel format. Once added to ArcMap, you can open the table from the Source view of the table of contents. Worksheets or named ranges with names containing spaces have single quotation marks placed around the table name. When accessed from ArcGIS, a worksheet is shown as a table with a dollar sign ($) at the end of its name, but a named range does not have a dollar sign. Any name references to cells or ranges defined in Excel are preserved in ArcGIS. For example, if you have an Excel workbook called Sales_Figures.xls that contains three worksheets-Sales, Month, and Year to Date-each worksheet is a separate table in ArcGIS. When you browse to an Excel file, you will need to choose which table you want to open.
For example, you can add them to ArcMap, preview them in ArcCatalog, and use them as inputs to geoprocessing tools.Įxcel files are added to ArcMap in the same way as other data, through the Add Data dialog box. You can open Microsoft Excel tables directly in ArcGIS and work with them in the same way as other tabular data sources. Understanding how to use Microsoft Excel files in ArcGIS
0 kommentar(er)
