Field data Insert

Help Activities
, , ,
1

Hi , I want to insert some data to column ‘P’…first row needs to be the header which I have to give it a name as ‘Results’,then for each row following the header row I insert data

image
image664×233 7.94 KB

2

@Anelisa_Bolosha1

Let me know if my understanding is wrong, you have an excel file and you have some data that you need to enter in the column “P”

If that correct Follow the below steps,

  • Add the use excel file activity.
  • use write cell activity and in that add the column as “P1” and enter your column name.
  • after that you can add for each row and in that you can add one write cell activity to add the data in the column, ensure in cell property you need use “P”+currentIndex+2. This will ensure the data feed from under the Results column.

Let me know if that works.
Happy Automation.

3

Hi @Anelisa_Bolosha1,

You can achieve by using Write Cell and Write Range activities.

  • Use Write Cell activity.
    • Cell: “P1”
    • Value: “Results”
  • Store your results in a “DataTable” which should contain the data that you need to enter into the “P” column.
  • Then use Write Range activity
    • Starting Cell: “P2”
    • DataTable: your results DataTable
    • Include Headers: False

If you do not have your data into a DataTable then use For Each Row in DataTable activity and enter data into each cell using Write Cell activity for each row into “P” column.

Cheers!