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.
Note:
For workbook level controls of Data Connector, please refer to Wbk object. |
Property | Access | Description |
---|---|---|
wks.DC.Source$ | Read/write string |
Relative path of data source. |
wks.DC.Path$ | Read/Write string |
Absolute file path of data source. Return empty if not File path (the data source is from web for example). |
wks.DC.Sel$ | Read/Write string |
Specify the selection of sheets/table inside the data source. Since CSV file has only one sheet, it doesn't have selection. |
wks.DC.Valid | Read/write numeric |
Check the status of Data Connector added to the worksheet:
0 = has no Data Connector, |
wks.DC.Allow() | Read/write numeric |
Check if the worksheet is used as the destination of a Data Connector: 0 = false, 1 = true |
wks.DC.IMPORT() | Read/write numeric |
Import data into current sheet, without opening the Import Options dialog. |
wks.DC.SType | Read/write numeric |
Data source type. It can be
0 = absolute file path, this is the only value that is read-write |
wks.DC.RESET() | Read/write numeric |
Clear imported data. The connection will remain. |
//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(); };