Reading a Microsoft Excel Spreadsheet into Arc
Installation (revised on April 27, 2009)Depending on your version of Excel, right-click on the appropriate link below, and save the file to your hard disk in any convenient place:
UsageCreate your data file in an Excel spreadsheet, with (1) the variable names in one row of the spreadsheet, and with (2) the values of the variables immediately below the variable names. For example, if you have 4 variables, the first row of the spreadsheet might give the names of the four variables in columns C to F, and the next 100 rows might give the values of the variables for the 100 data points in columns C to F. Any blank value will be converted to a missing value. Any cell consisting of a single period (the usual SAS missing data indicator) will be converted to the Arc missing value indicator. Text values are permitted; text may include spaces or special characters.
Next, from the Tools menu in Excel (Office 2003) or the Add-Ins tab (Office 2007), select the sub-menu Arc, and then the item Export data. This will give you a dialog in which you can do four things:
Correcting problems with writing filesArc.xla uses DDE, an abbreviation for direct data exchange, to write a temporary file to the directory C:\TEMP. Make sure that this directory exists on this system and that you can write to it.. If you cannot write to this directory or otherwise want to use a different temporary directory, you may modify the code for Arc.xla as follows: With the add-in installed and enabled, start Excel, press Alt-F11, and locate the module "ArcExportCode" under Arc.xla. Near the beginning of that code are two lines that look like this:
Const ArcTempFile As String = "c:\temp\arc_temp.lsp"These define the location of the temporary file. Modify these lines to point to a file that you can write in, possibly in your ``My Documents'' directory, and then do File/Save to save the changes. The two lines must give the same path and file name, one of them with "\"s, and the other with "\\"s between directory elements.
Arc.xla was written by Russell V. Lenth of the Department of Statistics & Actuarial Science, The University of Iowa. Here is his Web page.
Contact us! firstname.lastname@example.org
Revised, March 25, 2010.