I write a lot of scripts that have to use Excel data. I use the following workaround:
dt0 = Open( "data.xls");
// column labels in 4th row
labelrow = 4;
For( i = 1, i [less than]= N Col( Fdt0 ), i++,
:Column( i ) << set name( :Column( i )[labelrow] )
);
Fdt0 << delete Rows( 1 :: labelrow );
(message gets cut off when I use < above - bit of a problem for including JSL :( )
All of the columns are this way imported as character, which is actually good because I find often in excel apparently numeric columns will contain some characters (eg people love to add * or < to numbers), which would import as missing values if the column was recognised as numeric.
Cheers, Gunter
Message was edited by: GH
Message was edited by: GH