Table of Contents | ||||
---|---|---|---|---|
|
Excerpt | ||
---|---|---|
| ||
ExcelWriter interacts with existing Workbook content in two possible ways when importing data. |
Introduction
There are two ways to insert rows of data using ExcelWriter:
- ExcelTemplate's #ExcelTemplate.BindData method
- ExcelApplication's #Worksheet.ImportData method
ExcelTemplate.BindData
...
Before/After 'SUM' formula:
Before/After formula:
Worksheet.ImportData
When data is imported into a worksheet using ExcelApplication's Worksheet.ImportData (API Reference), the following is true:
...