Copy data from Excel to Variable Table


#1

This example shows how to paste variable table information from an excel spreadsheet into the variable table in RMCTools. DWORDS and arrays (ex. REAL[5]) make copying into the variable table somewhat difficult. Following this procedure, any properly formatted variable table info can be pasted from Excel into the variable table.

The project and Excel file used in this example are attached. If DWORDS and array data types are not used, steps 3, 5 and 6 can be omitted.

  1. Start with an empty Variable Table
  2. Format the Excel data in the same format as below snapshot
  3. Filter out the BOOL values in the Excel spreadsheet (only if the data contains DWORDS)

  4. Copy the Type column in Excel and paste into the first Type cell in RMCTools
  • Cell to paste in is outlined in Red. Snapshot shows the variable table after all the steps are complete

  1. Remove the filter applied in Step 3
  2. Expand all the DWORDS and ARRAYS in the Variable Table (Click on the plus sign to the left of the variable name)
  3. Copy and paste the Tag Name, Retain, and Initial Columns individually

Variable Table Copy.rmcproj (34.6 KB)
ExcelCopyExample.xlsx (22.1 KB)