How To put the Excel formula in Write cell Dynamical

Screenshot 2022-02-07 110831

For first row it would be =G2-I2 for second row =G3-I3 for third row =G4-I4

Hi

I would like to clarify few things with your scenario

  1. First write cell activity will not take a range
    And as I can see in the image we have mention as J2:J99

It can take only one cell like
J2

  1. Second is when we want to drag a formula to entire column then use Autofill activity

For more details have a view on these steps

  1. Drag and Drop an Excel application Scope Activity from the activities panel to the designer panel as shown below:

excel application scope

  1. Drag and Drop a Write cell activity from the activities panel to the designer panel to write the formula in the required column.

  2. Drag and Drop Auto fill range activity from activities panel to the designer panel as shown below:

auto fill the whole column

Here:

In write cell activity we used a simple formula that adds both values which are in column A and column B.

The formula is this =SUM(A2,B2)

This formula is written in the C column and applied to the rest of the column by using autofill range activity.

Let’s see the required properties for auto fill range activity:

auto fill range

  • FillRange: Provide the cell range that we need to fill that formula as shown above.
  • SheetName: Provide the sheet name that you want this to happen.
  • SourceRange: Provide the cell value where the formula is written.

Cheers @Gopi_Krishna1

1 Like

Hi @Gopi_Krishna1

I have tried your problem and I think I have found a solution for it.
Instead of using Workbook Write Cell, try using Excel Application Scope Write Cell.
Write your range as β€œJ2:J99”
and put your formula as β€œ=(G2-I2)”

How To put the Excel formula in Write cell Dynamical

This will update the formula for the whole range dynamically.

I hope this helps you.
Cheers