3.7.5.104.8 wks.DC.Script$

Syntax

wks.DC.Script$

Access

Read/write
string

Description

Get or set post-import scripts with data connector.

Examples

The following script sets up CSV data connect in new book with sample CSV data and run script to add "Mean" label row to show mean values of each column of the imported data.

newbook;
wbook.dc.add("CSV");
wks.dc.source$=System.path.program$+"Samples\Batch Processing\T275K.csv";
wks.dc.script$="wks.userparam(++Mean);
loop(i,1,wks.dc.c2) { wcol(i)[Mean]$="=Mean(this)";}";
wks.dc.import();