Importing and Exporting Values into Data Tables

You can import and export values to and from a Data Table via Excel or .csv file, as well as write values directly to, and read then from a Data Table in the PLC itself.

You can use the Excel ribbon tabs to write values to a data table via Ladder by following the steps below:

1. Create an Indexed Data Table (DTI), and link it to a Struct.

   

2. With the Data Table open, click Export Table Template to Excel and save the .xls file.

   
   

3. On your PC, open the .xls file, enter values, and save the file.
   

   
   

4. Create Unitronics Data Table file:

   1. Click Create Data Table from Excel file.

   2. Open the .xls file.

   3. Save it as a .udtf file

      

5. Download the .udtf to the SD in the controller.

   1. Click Download Data Table files to SD

   2. Select the controller

   3. Select the file
      

      
      

6. Use a "Load DTI from File" function to import the values into the Data Table RAM.
   

   

    

Range of Cells to/from .csv

To export a rang of cell values to .csv, highlight a range of cells, and click Export range to csv.

to import a range of cells, highlight them and click Import range from csv.

Read/Write Values to from PLC

If you are connected to the PLC, you can use the ribbon buttons to read and write values to and from Data Tables in the controller.