how to apply formulas in excel uipath

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

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)

Uiautomation

Help

PrankurJoshi (Prankur Joshi) May 24, 2018, 12:01pm 11

you are doing it correct -

see this How to insert data into database table?

Topic		Replies	Views
Is There an option In UiPath to convert Excel file into a database Studio datatable , excel , database , activities , question	3	1509	February 27, 2020
Problem to insert formula in Excel using Uipath Activities datatable , excel , studio , error	7	1874	January 21, 2022
Database issue Help studio	7	1789	October 6, 2017
Working with databases Help	5	1560	July 11, 2019
Excel as Database Help	2	1998	November 28, 2019

Uiautomation

Related topics