Use an Object array, IEnumerable, or IDictionary as the data source for an ExcelTemplate report.

Technical Overview

There are several ways to use standard arrays and collections as the data source for an ExcelTemplate report.  This demo shows how to use the following ExcelTemplate data source methods with arrays, array lists, and hash tables:

setDataSource

For using 2-dimensional, grid-like data stored in an array. Arrays can be arranged in [col, row] (normal) or [row, col] (transposed) fashions.

setColumnDataSource

For use with a 1-dimensional array, collection, or dictionary. Data is filled in the column.

setRowDataSource

Like setColumnDataSource, except data is filled horizontally by the row.

Click to run demo

Copyright 2005 © SoftArtisans, Inc. All Rights Reserved.