2.16.3.7 Details of TreeNodes in Import CSV


options

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

Syntax: Options.Treenode:=<value>

Example: Options.decimal:=1

Treenode Label Type Default Description
decimal Delimiter int 0 Specify a delimiter. Options include:
  • 0: Comma
    Data columns are delimited by comma.
  • 1: Semicolon
    Data columns are delimited by semicolon.
  • 2: Auto
    Data columns are delimited by auto-determined delimiter.
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.
  • 2: Start New Rows
    Add new rows to the target worksheet and import the data into the new rows.
Mode Multi-File (except 1st) 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.
  • 2: Start New Rows
    Add new rows to the target worksheet and import the data into the new rows.
WinTemplate Template Name String <default> 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> can be used to specify current workbook or matrix book as template to import files.
Sparklines Add Sparklines int 2 Specify whether to add sparklines for the data. Option list:
  • 0: No
    Do not add sparklines.
  • 1: Yes
    Add sparklines.
  • 2: Yes(if less than 50 columns)
    Add sparklines if there are less than 50 columns.
nAutoSize Auto Resize Cells int 1 Resize the cells of the worksheet automatically.

Options include:

  • 0: No
    Do not resize the cells.
  • 1: Width
    Just reset the width of the cells automatically.
  • 2: Height
    Just reset the height of the cells automatically.
  • 3: Width and Height
    Reset both the width and height of the cells automatically.
DataWriteProtection Data Protection int 0 Specify the imported data whether allow to be modified.

Options include:

  • 0: No
    The imported data can be modified.
  • 1: Read Only
    The imported data is not allowed to be edited and sorted
  • 2: Allow Sorting Only
    The imported data is not allowed to be edited, but can be sorted.
DateFormat Custom Data Format double Select a date format from the drop-down list, or type in a custom date format string. For more details, please see the [ Custom Date Format] page.

Options include:

  • <none>
  • yyyy'-'MM'-'dd HH':'mm':'ss
  • yyyy'-'MM'-'dd HH':'mm':'ss'.'###
  • yyyy'-'MM'-'dd hh':'mm':'ss tt
  • dd'/'MM'/'yyyy
  • dd'-'MM'-'yy
  • MM'/'dd'/'yyyy
  • MM'-'dd'-'yy
  • yy'/'MM'/'dd
  • yy'.'MM'.'dd
  • dd'.'MM'.'yy
  • yyyyMMdd
  • dd'-'MMM'-'yy
KeepDestColFmt Keep target column format int 0 Specify whether to keep target column format.

Names

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

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

Example:

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 (not including the file extension) as worksheet name.
  • Use the whole filename (including 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 workbook 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.
FNameToWksComm Appen Filename to Worksheet Comment int 0 Specify if the filename should be appended to the worksheet 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 whether to put the file name to 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 comment 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 workbook. For example, if you want to import a csv file named sample.csv, you can specify the setting as below to trim the extension ".csv" when renaming the workbook name:

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

HeaderLines

The HeaderLines branch of the Options tree specifies the header information of the data file.

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

Example: Options.HeaderLines.SNames:= 1

Treenode Label Type Default Description
MainHdrLns Number of Main Header Lines(exclude subheader lines) int 0 Some files -- particularly those generated by lab instrumentation -- will have, at the top of the file, some header information that typically identifies the instrument, the operator, the date, the sample number, etc. These are the main header lines. It is used to specify where main header lines are.
AutoSubHeaderLines Auto Determine Subheader Lines int 1 Select this check box to have Origin automatically determine the number of subheader lines. Note that it does not determine the structure of the subheader lines (e.g., which line is for long names and which is for units). If you want to manually specify the number, clear this check box.
SubHeaderLines Number of Subheader Lines int 0 It is used to specify the number of subheader lines of file.
ShortNames Short Names int 0 Specify which line of the file header to use for the short names of the worksheet row heading. Note that the number starts from the beginning of subheader lines rather than that of the whole header lines. Same for the settings below.

Note that from Origin 2017 column Short Name is restricted to alphabetical order and it cannot be edited by default. So Short Name option is hidden from GUI. If you want to rename column Short Names, you will need to go to the target workbook, uncheck Spreadsheet Cell Notation checkbox in the Properties tab of Window Properties dialog to enable editing column Short Name.

LongNames Long Names int 0 Specify the line for long names.
Units Units int 0 Specify the line for units.
CommentsFrom Comments From int 0 Specify the line which the comments start from.
CommentsTo Comments to int 0 Specify the line which the comments end with.
ParamsFrom System Parameters From int 0 Specify the line which the system parameters start from.
ParamsTo System Parameters To int 0 Specify the line which the system parameters end with.
UserParamsFrom User Parameters From int 0 Specify the line which the user parameters start from.
UserParamsTo User Parameters To int 0 Specify the line which the user parameters end with.

partial

The partial branch of the Options tree specifies how to partially import the file.

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

Example:

Options.partial.Partial:=1
Options.partial.FirstCol:=1
Options.partial.LastCol:=3
Treenode Label Type Default Description
Partial Partial Import int 0 Set it to 0 to disable partial import; set it to 1 or 2 to enable partial import. 1 means apply partial import settings to all files and 2 means apply partial import settings to all files except 1st file.
FirstCol Start Column int 1 This is only available when Partial is enabled(set to 1 or 2). Specify the begin column for partial import.
ReadCols Read Columns int 1 This is only available when Partial is enabled(set to 1 or 2) and "Skip columns" is larger than 0. Specify how many columns to read before skipping column(s) for partial import.

Note that When you specify a number l for Read Columns and a number k for Skip Columns, l columns are imported while k columns are skipped for every l+k columns.

SkipCols Skip Columns int 0 This is only available when Partial is enabled(set to 1 or 2). Specify how many columns to skip after each reading for partial import.
LastCol To Column int 0 This is only available when Partial is enabled(set to 1 or 2). Specify the end column for partial import.
FirstSample From Row int 1 Specify the start row of the file to be imported. This is only available when Partial is enabled(set to 1 or 2).
ReadSamples Read Rows int 0 This works with Skip Rows. It is only available when Partial is enabled(set to 1 or 2) and Skip Rows is larger than zero.

Note that When you specify a number l for Read Rows and a number k for Skip Rows, l rows are imported while k rows are skipped for every l+k rows.

SkipSamples Skip Rows int 1 Some rows can be skipped according to the setting. This is only available when Partial is enabled(set to 1 or 2).
LastSample To Row int 0 Specify the end row of the file to be imported. This is only available when Partial is enabled(set to 1 or 2).

Script

The Script branch of the Options tree specifies the LabTalk scripts to run after file(s) being imported.

Syntax: options.scripts.Treenode:= <string>

Example:
//Plot second column for each imported file  :
options.scripts.ScriptAfterEachImport:="plotxy 2;";

//When all files being imported, loop over all worksheets in all workbooks and delete first 500 rows from column 1 to column 4.
options.scripts.ScriptAfterAllImport:=" doc -ef W { doc -e LW { range aa =1[1]:4[500]; del aa;}}";


Treenode Label Type Default Description
ScriptAfterEachImport Script after Each File Imported string "?" Specify LabTalk scripts that will be executed after each imported file.
ScriptAfterAllImport Script after All Files Imported string "?" Specify LabTalk scripts that will be executed only after all files being imported.