...
For example, we start with a simple template file that contains data markers:
Some things to note:
...
Content below the data markers
In this example, there is content below the data marker row (a Grand Total row and a blue footer row). This will be pushed down as new rows are inserted.
Before:
After:
- There are two formulas
- B4 contains a SUM formula that references a data marker cell. The lower boundary will expand to include new rows.
- C3 contains a formula that references a data marker cell. The row values will be updated for each new row.
Before:
After:
- The italic and red font formatting will be applied for each row of data that is imported
Before:
After:
Worksheet.ImportData
How does ExcelWriter create rows when inserting data?
...