Uiautomation

uiautomation

#1

how to apply formulas in excel uipath


#2

see this - Fastest way to write an excel formula into an entire column


#3

check this
Main.xaml (8.7 KB)


#4

fail to apply formula for each row in uipath tool…
how to apply formula for entire excel


#5

how to dump excel file into database


#6

You mean dumping into SQL server or dumping excel data into DataTable locally?


#7

i just started learning uipath …i want to do some oprtations on excel data that’s why i think dump my excel into database and write a query is it a best way or anything else i do…


#8

You can use Read Range activity for excel sheet and modify the data while using for each loop and dump the modified data into a datatable variable which can further be Write into excel sheet


#9

or any suggestion for dumping into database…
i write this script…Main.xaml (9.6 KB)


#10

it gives this error


#11

you are doing it correct -

see this How to insert data into database table?


#12

it gives me error