The Sample Project

The sample project will be available for each major version. The current version can be downloaded from here. Some of the sample uses the Adventureworks database(2016 CTP3), but you don't need it to run most of the samples.

The following samples are available:

Basic sample creating a workbook

Reads sample 1 again

Database sample using the Adventureworks database.

Database sample using the Adventureworks database.

Reads sample 1 as a template and adds a piechart.

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

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

Uses linq to read the sample 7 workbook.

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

A little quiz showing encryption and protection of workbooks.

Datavalidation

Pivot tables & Pivot charts

Shows the LoadFromDatatable and LoadFromCollection methods

Conditional formatting

VBA

Sparklines