How to write value corresponding to any specific column name where all column has One header

Help Studio
, ,
2

@HELZMOTH_BJ,

  1. Use excel process scope activity - Find/Replace Value activity to find the desired column. This Find/Replace Value activity will give you the B column cell address.

  2. Use this regex to get the row number from the address string we got from step 1

strRowNumber = System.Text.RegularExpressions.Regex.Matches(strCellAddress, "\d+")(0).Value
  1. Now Use Write Cell activity and pass this "E"+strRowNumber in the property - Where to write and in What to write property, give your value to be written