Wks-DC-obj
Data Connector added to a worksheet are handled as objects in Origin. The column attributes can be accessed and changed using the properties in the table below.
For workbook level controls of Data Connector, please refer to Wbk object.
0 = (default)) Do not append 256 = append data rows to current sheet on import
0 = not dirty 1 = not imported yet 2 = imported but data is cleared, either by Clear Worskheet, or when open from OPJU 3 = dirty, outside file is newer 4 = web content, maybe dirty
0 = has no Data Connector, 2 = worksheet has not been used as destination by any Data Connector, 3 = worksheet is the destination of a Data Connector. You can then use "wks.DC.Source$" to check its data source. 4 = Data Connector has an invalid data source. 5 = source changed.
0 = false, 1 = true, 2 = clean up existing File Import information. If an analysis template imported data with import X-Function in the first place and uses Data Connector to import data later (this may be the case if the template was made in some old version like Origin2019 and reused in newer version like Origin2020b), set Allow to 2 to clear old import info saved in the worksheet: wks.DC.allow(2)=; It will return 1 if worksheet is the proper type and File Import Info if present has been removed.
0 = absolute file path, this is the only value that is read-write 1 = project relative file path 2 = common data relative file path 3 = web
//This example shows how to import a CSV file by Data Connector newbook; wbook.dc.add("CSV"); wks.dc.source$=System.path.program$+"Samples\Batch Processing\T275K.csv"; wks.dc.import();
//Import data to all DC-containing books in the Project Explorer (PE) folder doc -ef LBC { wks.dc.import(); };
//Import data to all DC-containing books in the entire project (all PE folders) doc -e LBC { wks.dc.import(); };