Excel Automation - Insert Rows in Excel Sheet with Workbook Activities

Help Studio
, ,
1

Hello,

I am attempting to complete an Excel Automation using Workbook Activities that performs the following steps:

  • Reads an External Data Table using Workbook Read Range
  • Writes Range using Workbook Write Range into an existing Excel Template (The excel template has a cell at the bottom of the column with a built in formula that sums all values in Column M and Column N)

The amount of rows in our data table is often larger than where the formula exists and overwrites the formula.

Is it possible to insert blank Excel Rows above the cell containing our formula, and then pasting our data table so we do not overwrite the built in formulas?

Thanks!

2

Hi did u tried with append range activity?

@verdonej

3

Hello,

Yes I have tried the Append Range Activitiy. This activity adds additional rows at the end of the data table.

Rather I’d like to add my data table above the final row of the Template.