Importing Data from Excel Files into the Utilities Datasheet

RockWorks | Utilities | File | Import | Excel

This program is used to import into the Utilities datasheet the entirety of a specified worksheet (.xls or .xlsx) created by the Microsoft Excel program. The imported rows and columns will be placed in the active RockWorks datasheet, starting at the row in which the cursor is currently placed. Once the data is displayed in RockWorks, you can modify the column names and types using the Columns | Column Properties command.

In order to use this import tool, you must have Microsoft Excel installed on your computer. The Excel program will be launched, and the selected file opened. The selected worksheet's data will be imported into the current RockWorks data sheet, starting at the current cursor location. The header of the datasheet will be modified to list the Excel column headings if you so requested. The Excel program will be closed automatically.

Menu Options
Step-by-Step Summary

Menu Options

• Existing Excel File: Click here to browse for the name of the Excel file to be imported, in an ".xls" or ".xlsx" format.  Note: Microsoft Excel must be installed on this machine in order for the OLE import to take place. Data will be added to the spreadsheet starting at the currently active row. This import will start on the first row of the Excel spreadsheet and stop when the first blank row of cells is encountered.

• Header Line: Insert a check in this box if the first row in the Excel file contains column headings rather than data. Clear this check-box if there are no column headings in the first row of the file being imported.
• • Process Header Line: If you've checked the Header Line box, click here to have RockWorks use the header line to define the column headings in the datasheet to be created.
  • Ignore Header Line: Choose this option to tell RockWorks to ignore the header line in the Excel spreadsheet.
• Datasheet: Since Excel permits a single spreadsheet file to contain more than one worksheet, here you can select which worksheet to import into RockWorks. Type in the proper worksheet number (default = 1).
  
  

Step-by-Step Summary

1. Access the RockWorks Utilities program tab.
2. Create a new, blank datasheet by choosing the File | New | Blank menu option.
3. Select the File | Import | Excel menu option.
4. Enter the requested menu settings, described above. 
5. Click on the Process button to import the data into the datasheet.
   
   The selected worksheet's data will be imported into the current RockWorks datasheet, starting at the current cursor location. The datasheet headers will be modified to list the Excel column headings if you so requested.
   
   
6. Use the Columns | Column Properties menu option to define column titles, column types, and units for any spatial data.
7. Use the File | Save menu option to save the imported data in a RockWorks ".RwDat" format.

"Microsoft" and "Excel" are registered trademarks belonging to Microsoft Corporation. RockWare does not have any claim whatsoever to these trademarks, formats or other trade secrets that belong to Microsoft.

  Back to Importing Data

RockWare home page