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.

Properties and Methods

Property Access Description
wks.DC.Source$ Read/write
Relative path of data source.
wks.DC.Path$ Read/Write
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
Specify the selection of sheets/table inside the data source. Since CSV file has only one sheet, it doesn't have selection.
wks.DC.Sstatus Read Only Source Status:

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

wks.DC.Valid Read/write
Check the status of Data Connector added to the worksheet:

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.

wks.DC.Allow() Read/write
Check if the worksheet is used as the destination of a Data Connector: 0 = false, 1 = true
wks.DC.IMPORT() Read/write
Import data into current sheet, without opening the Import Options dialog.
wks.DC.SType Read/write
Data source type. It can be

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

wks.DC.RESET() Read/write
Clear imported data. The connection will remain.
wks.dc.optn$ Read/write
Get or set connecotr settings as a string. Supported only for CSV, Excel etc connector types using its own GetN dialog.


//This example shows how to import a CSV file by Data Connector
wks.dc.source$=System.path.program$+"Samples\Batch Processing\T275K.csv";
//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(); };