Intro
Use a variety of .NET data types to populate ExcelTemplate includingstring[]
, ArrayList
, and Hashtable
.Methods used:
- 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 - For use with a 1-dimensional array, collection, or dictionary. Populates with only a single row of the data source. There must be a data marker for every column you want to be shown.
Code
Downloads
- Template:ArrayDataSourceTemplate.xlsx
- Output:ArrayDataSource_output.xlsx