Database and excel operation

[AshwinS2 (Ashwin S)]

hi @Maheshwar_Matalwar

Check the below post

SQL Function in Excel automation

add datacolumns new value and y/n to DT1 Foreach DT 1 row { rowArray = DT2.Select("Max> int.parse(row(2).Tostring) and Min<int.parse(row(2).Tostring()) you will get row array here (1 row)—> get new value and y/n row(“newvalue”)= newvalue from rowarray; row(“y/n”)= y/n from rowarray; }

Thanks
Ashwin S