Location
User guide
×
Menu
Index
  • 2. html
  • 2.244. Importing Microsoft Excel Data
Importing Microsoft Excel Data
Excel coordinate files can be imported into the Terrain Module using menus File - Open and File - Insert File
The process for importing coordinate data from Microsoft Excel worksheets is very similar to importing data from ASCII coordinate files.  The main difference is that there is no need to specify how to parse records and fields.  The coordinate information should be organized in rows and columns, each row being a separate coordinate and each column being a specific field.
NOTE:  The first line in the Excel file is assumed to contain column headings and is skipped when the file is read.
For more information on the options available, see the Import Excel Options dialog.
ODBC Driver NOTE
In order to import Excel you must have an ODBC MS Access driver installed. The default driver connection string is set to:
 
"DRIVER={MICROSOFT EXCEL DRIVER (*.xls)};DSN='';FIRSTROWHASNAMES=0;READONLY=TRUE".
This driver can be changed if required. See ODBC Sources in MS Windows.
 
 
 
If another driver is used, the [RoadEng] section of the Softree.ini file should be set to match the selected driver.