2.15.3.16 Details of TreeNodes in Import JCAMP

Options

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

Syntax: Options.Treenode:=<value>

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


Treenode Label Type Default Description
DecimalMark Decimal Mark int 0 Specify the decimal mark of the data.
  • 0: Period
  • 1: Comma
FirstMode 1st File Import Mode int 0 Specify the import mode for the 1st file.
  • 0: Replace Existing Data
  • 1: Start New Columns
  • 3: Start New Books
  • 4: Start New Sheets
Mode Multi-File (except 1st)Import Mode int 4 Specify the import mode for multi-file.
  • 1: Start New Columns
    Append new columns to the target worksheet for imported file.
  • 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.
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
bSaveFileInfo Save File Info. in Workbook int 1 If not selected, the file information will not be saved in Organizer and the reimport will not work, but the import speed can be improved.


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 It is aviable only when Rename Sheet with (Partial) Filename has been selected. It specify the start position of the name.
FNameToShtTo Trim Filename To int 0 It is aviable only when Rename Sheet with (Partial) Filename has been selected. It specify the end position of the name.
FNameToBk Rename Book with (Partial) Filename int 0 Check this to use part of the filename as workbook name.
FNameToBkFrom Trim Filename From int 1 It is aviable only when Rename Book with (Partial) Filename has been selected. It specify the start position of the name.
FNameToBkTo Trim Filename To int 0 It is aviable only when Rename Book with (Partial) Filename has been selected. It specify the end position of the name.
FNameToBkLnOnly Rename Long Name for Book only int 0 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 File 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.
Notes:

From Origin 8.6, minus value is supported in FNameToBkFrom and FNameToBkTo to count the end of the name from the last character of the file name. It can be used to trim the file extension when you rename book. For example, if you want to import a JCAMP-DX Version 6 file named sample.dat, you can specify the setting as below to trim the extension ".jcm" when renaming the workbook name:

Options.Names.FNameToBkFrom:=1
Options.Names.FNameToBkTo:=-4