I assume by product code you mean a concatenation of column product and a substring of column code. In that case, loop over each row, and set
Row("product code") = Row("product").Trim + "-" + Row("code").Trim.Substring(4,4)
Alternatively, you can do the same by reading the sheet into memory, using a For Each Datarow activity, and then rewriting the sheet into Excel with a Write Range.
Your steps would be as follows below
Read range the excel using excel read range
For each row in readDt
Currentrow(“Productcode”) = currentRow(“Product”).toString+"-"+Currentrow(“Code”).tostring.substring(Currentrow(“Code”).tostring.Length-4)
Out side the Loop
Write range with same path,sheet,datatable as readrange
Assign:- Counter=1 ->Int32 variable
use write cell activity-> Value->
Range in write cell: “D”+(Counter+1).ToString
Have a look here:
How to Update Data Column Values of a Data Table | Community Blog
the concatenation is a good case matching to the Datacolumn.Expression approach
Nice, never knew about the DataColumn.Expression method.
Shame the article doesn’t include/compare execution time though.
Hope you have got your solution with such wonderful explanations from my fellow mates. Please tick the appropriate thread as the solution so that the thread can be closed and others can get help with it.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.