2.16.3.20 Details of TreeNodes in Import MDF


Options

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

Syntax: Options.Treenode:=<value>

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


Treenode Label Type Default Description
selectionmode Import with Data Group int 0 Specify whether to import the data with group. If checked, the File Info and Data Selection branch will list the available groups.
rawdata Import Raw Data int 0 Specifies whether or not the raw data is imported.
FirstMode 1st File Import Mode int 0 Specify the import mode for the 1st file.Options include:
  • 0:Replace Existing Data
    The data that exists in the target window will be wiped out. And the new data will be imported into it.
  • 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.
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.
WinTemplate Template Name String This option is available when the Import Mode is Start New Sheets or Start New Books. Specify the template to import the file to a new book or new sheet. A special template <clone> is to use current workbook or matrix book as template to import files. Note: when importing a multi-sheets Excel book into the specified workbook template which contains empty worksheet(s), you can refer to system variable @ISE for additional control over importing behavior.
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
bStructureOnly Import Structure Only int 0 Specify whether only the structure of the file will be imported. If only the structure is imported, you are able to import selected data range by the reimport X-Function.
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 hwo 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 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 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.
English | Deutsch | 日本語