Hi there,
I want to import multiple ascii files via drag and drop and do some statics on them. Every file is imported as new a worksheet. The labtalk code for the iw filter is to calculate min and max values of some columns. The values then are displayed in a seperate worksheet as "summary". The scripts runs first for every imported file.
This is first time I am writing a labtalk code and its quite hard with the documentation So what my code does it creates a new worksheet and then long name and units are changed. But there are no values inside of worksheet overview. I am confused with the range objects. The error is that mathematics cannot be run on text ..
It would be really nice if you could help me out here.
range rcol2 = Col(2)
range rcol6 = Col(6)
range rcol9 = Col(9)
var_R2_min = stats.min rcol2;
var_R2_max = stats.max rcol2;
var_R4_min = stats.min rcol6;
var_R4_max = stats.max rcol6;
var_MR_max = stats.max rcol9;
newsheet name:=Overview cols:=6;
range rOverview = Overview!
page.active$ = Overview;
if (col(6)[L]$ != maximaler MR Effekt)
{col(1)[L]$ = Messung;
col(2)[L]$ = minimaler R2 Widerstand;
col(2)[U]$ = Ohm;
col(3)[L]$ = maximaler R2 Widerstand;
col(3)[U]$ = Ohm;
col(4)[L]$ = minimaler R4 Widerstand;
col(4)[U]$ = Ohm;
col(5)[U]$ = Ohm;
col(5)[L]$ = maximaler R4 Widerstand;
col(6)[L]$ = maximaler MR Effekt;
col(6)[U]$ = %;}
range rcol2 = Col(2)
range rcol3 = Col(3)
range rcol4 = Col(4)
range rcol4 = Col(5)
range rcol4 = Col(6)
wks.col(2) = var_R2_min;
wks.col(3) = var_R2_max;
wks.col(4) = var_R4_min;
wks.col(5) = var_R4_max;
wks.col(6) = var_MR_max;
Best regards,
Clemens