Auto Fill Range Dynamically

hi,
i have an excel file.it contain 3 columns.

in Transaction Date Column have to fill Auto Fil based on the last row of that column.
exp–C8(16-Jan-22) have to fill remain rows.

Can any one help ?

AutoFill.xlsx (9.3 KB)

@Anand_Designer

You mean want to increment day by day for each row in Transaction Date column ?

If yes then use Auto Fill Range activity and mention Source and Fill Range as below.

SourceRange: “C8”
FillRange: “C9:C20”

@Anand_Designer Some times the last row might change, For now it is 8th row , some times it could be some other row. If there is such scenario in your case please use the below workflow

Example.zip (10.3 KB)

Input

1

Output

2

this file will send by client, we dont know how many rows they filled for Trnsaction Date . some times they will give Data upto C10 or C15. based on last row , we have to auto fill.

@Anand_Designer

Hope you know the last column name. If yes then follow below steps.

  1. Use Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say dtInput.

  2. And then find the row count as below.

     rowCount = dtInput.Rows.Count
    
  3. Finally pass the FillRange as below.

         "C8:C"+rowCount.ToString
    
1 Like

Thanks For given solution

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