Import Excel data in TTY mode
- Last UpdatedDec 05, 2025
- 1 minute read
Use this feature to import data from an Excel file into the application. For detailed instructions, see Import Data From Excel.
Example
Use the commands in this table to import Excel data into the application.
|
Command |
Description |
|---|---|
|
!e = object excelio() |
Initializes the Excel object. |
|
!e.import('C:\EXCEL\VALVTAG.xlsx', 'Test1') |
Imports the data from the Excel file located at C:\EXCEL\VALVTAG.xlsx into the target configuration Test1. |
|
!e.import('C:\EXCEL\VALVTAG.xlsx', 'Test1', false) |
Imports data into Test1 using defined naming rules instead of Excel names. |
|
Savework |
Saves the imported data to the Dabacon database. |
You can create tags using defined naming rules by using the new PML import method:
!e.import('C:\EXCEL\VALVTAG.xlsx', 'Test1', preserveName)
-
Set preserveName to true to preserve tag names from the Excel sheet.
-
Set preserveName to false to create tag names using the naming rules.
Note: The old method !e.import('C:\EXCEL\VALVTAG.xlsx', 'Test1') still works and, by default, preserves the Excel names.