Insert 0 into particular columns in an excel sheet till end of rows

Help Studio
, ,
1

image
image596×741 9.51 KB

How to insert 100 as values into the columns named FRI and SAT until the last row.

2

Hi @vidyasak ,

we can do in many ways.

  1. Read the excel. you would get the data in data table.
  2. Int counter_ = 1;
  3. iterate for datatable using for each row in datatable
  4. section use activity Write cell activity. mention the range value K + count.
  5. Increment the counter_ value
  1. Read the excel. you would get the data in data table.
  2. iterate for datatable and update the row value
  3. create the excel again
  1. create a macro in the excel.
  2. Invoke macro
3

Thanks Siva for the solution. Can u share a sample code for the second option.

4

Hi @vidyasak ,

here is the code.
BlankProcess1.zip (151.0 KB)

1 Like
5

Thanks @Siva_krishna_Thumma :slight_smile:

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.