I am trying to use the “Fill Range” activity to populate an Excel worksheet’s column using Excel’s SUMIF function. Now that my first row contains headers, I want the range fill to happen from the second row.
Where to Write, I can’t seem to use options like
<SheetName>D2:Das it results in a not found error
D:Dworks but it writes values from the first row
- Ideally, I would like to use only the filled rows and not until the end of the worksheet as D2:D would probably do if it worked, but I am not aware of how to limit that.