Search results

  1. T

    Convert to numeric

    select sum (iif(isnumeric() = true, ,0)) as SumofB from Sheet1$
  2. T

    Convert to numeric

    A B C 10 -- -45.20 -50 -- -50.6 select sum (iif(isnumeric() = true, [A],0)) as SumofB from Sheet1$ this return null value, how to check numeric on column B because of double --
  3. T

    how to get excel values

    how to define dynamic array and assign value to each row & column. for example select distrinct (data1) as col1 from excelsheet then i have 10 records. how to re-define array variable so i can start loop through data from sql record set to array (row,1)= datasetcolumn (1)
  4. T

    AA ObjectCloning time for waiting object

    i often uses Wait command or loop command with combination of If statement for waiting until object is appeared, this is waste of time, with Object Clonning statement it also wait for object to appear but only in short time, is there any tips let AA to wait until object appear. thanks so much
Top