The Sample Project

The sample project is available as a download with each version. No versions are available at Github at this moment, but version 4.1 can be downloaded from Codeplex.
Version 4.5 beta will be available here shortly. You can of course clone this repository to get the latest code here. The following samples are available:

Sample 1

Basic sample creating a workbook

Sample 2

Reads sample 1 again

Sample 3

Database sample using the Adventureworks database. Uses an old version of the database.

Sample 4

Database sample using the Adventureworks database. Uses an old version of the database.

Sample 5

Reads sample 1 as a template and adds a piechart.

Sample 6

Creates an more advanced report showing styling, shapes, charts, comment and tables.

Sample 7

Shows the perfomance capabilities, loading 64k rows, adds some Formulas and style the workbook. This sample also shows how to protect a workbook

Sample 8

Uses linq to read the sample 7 workbook.

Sample 9

Loads two csv files using the LoadText method. Shows tables and charts.

Sample 10

A little quiz showing encryption and protection of workbooks.

Sample 11

Datavalidation

Sample 12

Pivot tables & Pivot charts

Sample 13

Shows the LoadFromDatatable and LoadFromCollection methods

Sample 14

Conditional formatting

Sample 15

VBA