Downloads
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 (this tutorial uses a web application).
- Add a reference to SoftArtisans.OfficeWriter.ExcelWriter.dll
- SoftArtisans.OfficeWriter.ExcelWriter.dll is located under Program Files > SoftArtisans > OfficeWriter > bin
You can download the Hello World sample code (C# or VB) 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.
Unknown macro: {div5}
Hello World: Programmatic Approach
With ExcelApplication's full object-model, we can create an excel file completely from scratch.
Unknown macro: {div5}