How to fill the specific cell in excel without using write cell activity

[lakshmi.mp]

Hi all,
How to fill the specific cells in excel without using write cell activity, I used write cell activity it’s taking more time to complete execution. Please guide me on this.

[rlgandu (Rajyalakshmi Gandu)]

@lakshmi.mp

Use “Write cell workbook activity” to write or use vba macros code to write data in specific cell. These two take less time when compared excel process scope activities

[anilkupatnaik (Anil Kumar Patnaik)]

HI @lakshmi.mp

Are you providing any formula in excel using write cell activity?

Regards

[pravallikapaluri]

Hi @lakshmi.mp

Use Macros

Sub FillCells()
    Sheets("Sheet2").Range("A1").Value = "Hello"
    Sheets("Sheet2").Range("B1").Value = "World"
End Sub

[lakshmi.mp]

@anilkupatnaik ,

please check the screenshot
“X”+(Counter+1).ToString

[anilkupatnaik (Anil Kumar Patnaik)]

HI @lakshmi.mp

You need to use the write cell workbook activity or else use the invoke code activity instead of write cell workbook.

Regards

[pravallikapaluri]

Hi @lakshmi.mp

Instead of for each row in datatable,Use For each

For Each row As DataRow In yourDataTable.Rows
    row("ColumnName") = "Yes"
Next

If you dont know the column name ,For “X” column

For Each row As DataRow In yourDataTable.Rows
    row(23) = "Yes"
Next

Hope it helps!!