| Note |
|---|
| icon | false |
|---|
| title | Prerequisites |
|---|
|
You will need ExcelWriter 8 installed in order to run the Hello World sample. - If you haven't purchased ExcelWriter, you can download an evaluation version here.
- If you need to install ExcelWriter, please visit the install page for instructions.
|
Downloads
You can download the code for the Hello World tutorial as a Visual Studio solution.
ExcelWriter Reference in Visual Studio
...
- Open Visual Studio and create a .NET project (this tutorial .
- 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 (C# or VBsee 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.
| Excerpt |
|---|
This tutorial will walk you through assigning the contents of a cell using ExcelTemplate and ExcelApplication. |
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| bgColor | white |
|---|
| titleBGColor | #EEE |
|---|
| title | Hello World: Template Based Approach |
|---|
| borderColor | #AAA |
|---|
| titleColor | #666 |
|---|
| With ExcelTemplate , we can insert our data into a specially formatted excel Excel file. Hello World using | Panel |
|---|
| bgColor | #6691BC |
|---|
| borderStyle | solid |
|---|
| borderColor | White |
|---|
| borderWidth | 20 |
|---|
| |
|
|
| Column |
|---|
| | Panel |
|---|
| bgColor | white |
|---|
| titleBGColor | #EEE |
|---|
| title | Programatic Hello World: Programmatic Approach |
|---|
| borderColor | #AAA |
|---|
| titleColor | #666 |
|---|
| | Wiki Markup |
|---|
With ExcelApplication's full object-model, we can create an excel Excel file completely from scratch.
{div:class=button-style}
[Hello World Using ExcelApplication]
{div}
|
|
|
Downloads
| Panel |
|---|
| bgColor | #6691BC |
|---|
| borderStyle | solid |
|---|
| borderColor | White |
|---|
| borderWidth | 20 |
|---|
| |
|
|
|
