| Wiki Markup |
|---|
{note: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|http://www.officewriter.com/trial].
* If you need to install ExcelWriter, please visit the [install page|EW8:Installation] for instructions.{note}
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.
|
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
...
...
...
...
...
...
...
...
...
...
...
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.
| 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 | Template Based Approach |
|---|
| borderColor | #AAA |
|---|
| titleColor | #666 |
|---|
| With ExcelTemplate, we can insert our data into a specially formatted excel file. |
|
| Column |
|---|
| | Panel |
|---|
| bgColor | white |
|---|
| titleBGColor | #EEE |
|---|
| title | Programatic Approach |
|---|
| borderColor | #AAA |
|---|
| titleColor | #666 |
|---|
| 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. |
|
|
Attachments
