Any references (A1:D6) are adjusted in the generated XLSX output to now be the new range based on the inserted data. This includes the case of a range inside a forEach loop, where the range will be adjusted for each set in each iteration of the forEach.
What does this mean? Say you have =SUM(C4:C4) in a cell. And when you generate the template the row 4 has become the rows 4 ... 15 when the data is inserted. Then that cell will now have =SUM(C4:C15). This is important because if you then change the value in cell C7, the SUM() will adjust to match this change. In short, this give you live worksheets.
