Wiki Markup |
{div:class=kate-style}
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.
[Download the Hello, World sample code]
{info}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| Docs:Installing OfficeWriter] for instructions.{info}
h3. Getting started with ExcelWriter in .NET
After ExcelWriter is installed, the next step is to create a .NET project and add a reference to the ExcelWriter library. These steps have already been done for you in the Hello, World sample.
# 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 |
---|
| |
|
|
|