The Options tree specifies all import options for the impExcel X-Function.
Syntax: Options..SubTree.Treenode:=<value>
Example: Options.Names.FNameToSht:=1
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
From Origin 8.6, minus value is supported in Trim Filename From and Trim Filename To to count the end of the name from the last character of the file name. It can be used to trim the file extension. For example, if you want to import an Excel book named sample.xls, you can specify as follow to trim the extension ".xls":
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;}}";