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.
h3. [Download the hello world sample code!]
{info}If you haven't installed ExcelWriter yet please visit the [install page| Installing ExcelWriter] for instructions.{info}
h3. Hello World with ExcelTemplate
h3. Hello World with ExcelApplication
h3. Next Steps
Once you have successfully given your salutations to the globe, it is time to continue your quest in becoming an ExcelWriter pro. Here's what you could do next:
{section}
{column:width=35%}
{tip:icon=false}
{align:center}*[Tutorials]*{align}
Check our our basic or advanced tutorials and soon you'll be an ExcelWriter pro!{tip}
{column}
{column:width=35%}
{info:icon=false}
{align:center}*[Programmer's API Reference]*{align}
Visit the Programmer's API Reference for in-depth knowledge on how a particular object or method works.{info}
{column}
{column:width=35%}
{warning:icon=false}
{align:center}*[Help]*{align}
Need help? We are here for you! You can file a support incident online and we'll get back to you shortly.{warning}
{column}
{section}
{div}
|
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 is located under Program Files > SoftArtisans > OfficeWriter > dotnet > bin
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 |
---|
| |
|
|
|