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)
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)
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
Output
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.
Hope you know the last column name. If yes then follow below steps.
Use Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say dtInput.
And then find the row count as below.
rowCount = dtInput.Rows.Count
Finally pass the FillRange as below.
"C8:C"+rowCount.ToString
Thanks For given solution
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.