Load on imported file into a tree
X-Function not designed for Auto GetN Dialog.
Command Line Usage
1. impinfo trinfo:=mytree; mytree.=;
2. impinfo findex:=0 trinfo:=mytree; ;
3. impinfo ipg:=book1 findex:=1 fcount:=mycount trinfo:=mytree;
The worksheet to which some files have been imported.
The index of the file that has been imported into the workbook. Note that the index of the first imported file is 1 and the index of the second imported file is 2... The default file index is 0, which corresponds to the last file that has been imported.
The tree for outputting the information.
See more details in Description table
Number of the imported file(s)
The impinfo function is designed to read the information from the binary storage of the specified workbook. The function finds multiple files only when multiple files have been imported into New Sheets, New Columns or New Rows of a WorkBook.
The following code uses impinfo to get a file count for a workbook, then to retrieve the file path and name from storage:
impinfo ipg:=[Book2] findex:=0 fcount:=MyCount; // Just to get the file count
// Now loop for each file
impinfo ipg:=[Book2] findex:=idx trInfo:=MyTree;
str1$ = MyTree.Info.FilePath$;
str2$ = MyTree.Info.FileName$;
ty File $(idx): %(str1$)%(str2$);
Type MyTree.= in the Script or Command Window and press Enter to see the tree structure. A dot in the name is used to axis a deeper node as in:
PlotType = MyTree.FilterInfo.Display.iPlotType;