Adding a column in existing excel

[Abhishek14 (Abhishek Kommera)]

I have an excel sheet in which i have 2 columns(Column 1/ Column 2) .and i am extracting a value from application
i.e. Var1 ( Int 32).
Now i want to add a column in the existing sheet(column 3) and want to use the formula
column 3 = column(2)/var1…

Thanks.

[KarthikByggari]

Use the write cell activity with a formula.

Refer:

Writing Excel Formula using Write Cell

Hi, I want to write this formula =COUNTIFS(A6:A255,“K”,J6:J255,“Red”) into the write cell under excel application scope but have this error. [Capture] Is there any way I can work this around? Must be something to do with the quotations. The quotations are needed for excel formula integration.

[Madhavi (K)]

@Abhishek14
As @KarthikByggari said, you can use write Cell activity.
Other options are,
-Create a Marco and run that Macro on the file.

-Calculate and Use write range:

1. Read excel data and add it into a datatable, dtData.
2. Add a column into the datatable using activity, AddDataColumn
3. Loop through each row. Calculate the column 3 value and update the value in column3.
4. Update the value in excel by using Write Range Activity.

[shruti (ss)]

Hi Abhishek
Main.xaml (9.7 KB)