2.15.3.25 Details of TreeNodes in Import PClamp


trfiles

The trfiles tree specifies the information of the file and data for the impPClamp X-Function.

Syntax: trfiles.Treenode:=<value>

Example: trfiles.ShowTimeCol:=1 // Add a time column


Treenode Label Type Default Description
Stimulus Stimulus int 1 Specify whether to import the stimulus data.
bHoldingDuration Shift Time by Holding Period int 0 Specify whether to shift the time by holding period.
ShowTimeCol Add Time Column int 0 Specify whether to add a time column.


Options

The Options tree specifies all import options for the impPClamp X-Function.

Syntax: Options.Treenode:=<value>

Example: Options.sparklines:=0 // Do not add sparklines


Treenode Label Type Default Description
Mode Multi-File (except 1st) File Import Mode int 4 Specify the import mode from the list for the files other than 1st. Options include:
  • 3:Start New Books
    Create a new book for the file that will be imported.
  • 4:Start New Sheets
    Create a new sheet for the file that will be imported.
  • 1:Start New Columns
    Add new columns to the target worksheet and import the data into the new columns.
sparklines Add Sparklines int 2 Specify whether to add the sparklines of the data.
  • 0: No
    Do not add sparklines
  • 1: Yes
    Add sparklines
  • 2: Yes(if less than 50 columns)
    Add sparklines if less than 50 columns
XFBar Show Control Panel for Making Plot int 1 Specify whether to show control panel for making plot.
bSaveFileInfo Save File Info. in Workbook int 1 Specify whether to save file information to workbook (Plotting requires file info should exist).



Names

The Names branch of the Options tree specifies how to name the worksheet and workbook.

Syntax: Options.Names.Treenode:= <value>

Example:
//Rename worksheet with partial filename  :
Options.Names.FNameToSht:=1
Options.Names.FNameToShtFrom:=1
Options.Names.FNameToShtTo:=4


Treenode Label Type Default Description
AutoNames Auto Rename using file name int 0 If it is checked, Origin will use the default settings to rename the worksheet and workbook name, which is:
  • Use the whole filename (includes the file extension) as worksheet name.
  • Use the whole filename (includes the file extension) as workbook name if current workbook is empty or the import mode is Replace Existing Data.
FNameToSht Rename Sheet with (Partial) Filename int 1 Check this to use part of the filename as worksheet name.
FNameToShtFrom Trim Filename From int 1 Specify the start of the name.
FNameToShtTo Trim Filename To int 0 Specify the end of the name.
FNameToBk Rename Book with (Partial) Filename int 1 Check this to use part of the filename as workbook name.
FNameToBkFrom Trim Filename From int 1 Specify the start of the name.
FNameToBkTo Trim Filename To int 0 Specify the end of the name.
FNameToBkLnOnly Rename Long Name for Book only int 1 Check this to rename the long name for book only.
FPathToBk Include File Path when Renaming Book int 0 Specify if the file path should be included for the workbook name.
FNameToBkComm Append Filename to Workbook Comment int 1 Specify if the filename should be appended to the workbook comment.
FNameToColComm Append Filename to Column Comment int 0 Specify if the filename should be appended to the column comment.
FNameToUDL Add Filename User Parameters Row int 0 Specify if the file name should be put to the column User Parameter row "SourceFile".
FPathToComm Include path when appending filename int 0 When this is checked, the import file path is appended to the workbook's command and/or Comments row.