Excel fill range from a specific row

Help StudioX
,
1

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.

  • In Where to Write, I can’t seem to use options like <SheetName>D2:D as it results in a not found error
  • D:D works 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.
2

Hello @gischethans
Try this

<SheetName>D2
3

HI @gischethans

Use only D2 and try once.

Regards
Sudharsan

4

@gischethans
image

5

I had tried that. It just fills D2. @Gokul_Jayakumar

6

@gischethans
Try this
Use Read range activity without header and range from D2, stored as DT variable.
Use Fill range activity with

Excel.Sheet("Sheet1").Range("D2:D"+(DT.RowCount+1).ToString)

image
image626×537 17.1 KB

1 Like
7

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