You can download the code for the Hello World tutorial as a Visual Studio solution.
ExcelWriter Reference in Visual Studio
Create a .NET project and add a reference to the ExcelWriter library.
- Open Visual Studio and create a .NET project.
- The ExcelWriter Hello World sample code uses a web application.
- Add a reference to SoftArtisans.OfficeWriter.ExcelWriter.dll
- SoftArtisans.OfficeWriter.ExcelWriter.dll is located under Program Files > SoftArtisans > OfficeWriter > dotnet > bin
You can download the Hello World sample code (see above) to see the finished product.
Template vs. Application based Approaches
ExcelWriter offers two approaches to generating, processing and manipulating Excel documents: ExcelTemplate and ExcelApplication.This tutorial will walk you through assigning the contents of a cell using ExcelTemplate and ExcelApplication.
Hello World: Template Based Approach
With ExcelTemplate we can insert our data into a specially formatted Excel file.
Hello World: Programmatic Approach
With ExcelApplication's full object-model, we can create an Excel file completely from scratch.