The For Each Row approach to filling values into columns can take a very long time for large tables. An activity that wrote formulas to every data row in a table column would be much, much faster.

Excel: Write Formula to Table Column

AndrewHall (Andrew Hall) April 1, 2021, 9:26pm 3

Hi Jack,

Take a look at the StudioX Business Fill Range and Auto Fill activities as I suspect they will give you what you want.

I see this is tagged Studiox, but in case you are in Studio, see the instructions here for how to access them in Studio UiPath Community 2021.4 Stable Release

Topic		Replies	Views
Dynamic Excel column reference in StudioX StudioX studiox , question	3	1550	November 28, 2022
Is it possible to refer to a range of Excel cells using structure reference (e.g., column names) in StudioX StudioX excel , studiox , question , structure-reference	1	839	December 1, 2022
Fastest way to write an excel formula into an entire column Help excel	38	37465	August 4, 2021
Auto fill formula in an entire excel column Help activities , question	4	4198	October 3, 2023
How to fill the formula in a each column in excel Activities excel , activities , question	6	882	July 21, 2022

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE
More details...

Excel: Write Formula to Table Column

Related Topics