Wiki Markup |
{info:title=Prerequisites |icon=false}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|EW8:Installation] for instructions.{info}
h1. 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 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
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
...
...
...
...
...
...
...
...
...
...
...
You can download the Hello World sample code (see above) to see the finished product.
Info |
---|
Please check out Adding OfficeWriter to your .NET Application for more on getting started with OfficeWriter |
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 file. Panel |
---|
bgColor | #6691BC |
---|
borderStyle | solid |
---|
borderColor | White |
---|
borderWidth | 20 |
---|
| |
|
|
Column |
---|
| Panel |
---|
bgColor | white |
---|
titleBGColor | #EEE |
---|
title | Hello World: Programmatic Approach |
---|
borderColor | #AAA |
---|
titleColor | #666 |
---|
| With ExcelApplication's full object-model, we can create an Excel file completely from scratch. Panel |
---|
bgColor | #6691BC |
---|
borderStyle | solid |
---|
borderColor | White |
---|
borderWidth | 20 |
---|
| |
|
|
|