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 --
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)
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.