Uiautomation

how to apply formulas in excel uipath

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

check this
Main.xaml (8.7 KB)

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

how to dump excel file into database

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

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…

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

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

it gives this error

you are doing it correct -

see this How to insert data into database table?

it gives me error