Hello All,
this is my first post - I'm trying to automate data processing where I receive data in the form of excel spreadsheets... There's one tab in the workbook with all the relevant information.
JMP appears to import a lot of the data as character, not numeric, and I can convert the data to numeric manually in the table (usual way) but not with a script:
Any ideas?
thanks
Tom
Set current directory("C:\JDSU\ServerCopy\Data\Post-processing characterization\Flash I-V\AWSC");
dt=open(); // this is the only way I've found to let me select the relevant worksheet "Sort Data" in the .xls file
tables = ntable();
OpenDTs = List();
savethis = list();
closethese = list();
show(dt);
/* THis loop I thought would work to eliminate the open tables which I don't want, but it only closes a few, not all, of the unwanted tables
for(i=1, i<=tables, i++,
Insert into( openDTs, Data Table(i)<<GetName());
IF(Data table(i)<<GetName() =="Sort data",
Continue();
close(DataTable(i));
);
);
*/
dt<<delete rows({1,2,3,4,5,6,7,8,9}); // the first nine rows are not data - is there a way to capture this in the open() command?
column (1)<<set name("Wafer ID");
column (2)<<set name("Xref-Yref");
column (3)<<set data type("numeric"); // this doesn't work....
//column ({3,4,5,6,7,8,9,10,11,12,13}) <<set data type(numeric); //nor does this
col = New COlumn("FF_Calc", numeric);
col<<set formula(:vmp *:imp /:Voc /:Isc); // this returns errors as I can't change the offending columns to numeric.
col = NEw COlumn ("xref", character);
col = new column ("yref", character);
column("voc")<<set data type("numeric"); //still doesn't work
