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
Unknown macro: {div}
You can [download the Hello World sample code] 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.
Template Based Approach
With ExcelTemplate, we can insert our data into a specially formatted excel file.
Programatic Approach
With ExcelApplication, we have a full object-model for the excel file format. This means that we can create an excel file completely from scratch.
Next Steps
Unable to render {children}. Page not found: ExcelWriter 8.0.