Copy data from Excel to Variable Table

Discuss and troubleshoot RMCTools along with RMC70, RMC150, and RMC200 motion controllers.

Copy data from Excel to Variable Table

Postby Paul Huumala » Wed Jan 31, 2018 4:58 pm

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
    RawDataExcel.png
    RawDataExcel.png (19.09 KiB) Viewed 46 times
  3. Filter out the BOOL values in the Excel spreadsheet (only if the data contains DWORDS)
    FilterOutBOOL.png
    FilterOutBOOL.png (13.18 KiB) Viewed 46 times

    RawDataExcelBOOLFilteredOut.png
    RawDataExcelBOOLFilteredOut.png (35.93 KiB) Viewed 46 times
  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
    DataRMCTools.png
    DataRMCTools.png (26.52 KiB) Viewed 46 times
  5. Remove the filter applied in Step 3
  6. Expand all the DWORDS and ARRAYS in the Variable Table (Click on the plus sign to the left of the variable name)
  7. Copy and paste the Tag Name, Retain, and Initial Columns individually
Attachments
Variable Table Copy.rmcproj
(34.6 KiB) Downloaded 5 times
ExcelCopyExample.xlsx
(22.1 KiB) Downloaded 4 times
Paul Huumala
 
Posts: 2
Joined: Wed Dec 20, 2017 12:01 pm

Return to RMCTools

Who is online

Users browsing this forum: No registered users and 1 guest

cron