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:

Sample 1

Basic sample creating a workbook

Sample 2

Reads sample 1 again

Sample 3

Database sample using the Adventureworks database.

Sample 4

Database sample using the Adventureworks 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

Sample 16

Sparklines