Intro
Use a variety of .NET data types to populate ExcelTemplate including string[]
, ArrayList
, and Hashtable
.
This example demonstrates how Excel Writer can use arrays, array lists and hash tables as data sources for an ExcelTemplate report.
- BindData - For using 2-dimensional, grid-like data stored in an array. Arrays can be arranged in [row,col] (normal) or [col,row] (transposed) fashions.
- BindColumnData - For use with a 1-dimensional array, collection, or dictionary. Data is filled in the column.
- BindRowData - Like BindColumnData, except data is filled horizontally by the row.
Code
Downloads
Template:ArrayDataSourceTemplate.xlsx
Output:ArrayDataSource_output.xlsx