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
{section}
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:
{div}
{column:width=30%}
h4. *[Tutorials]*
Check our our basic or advanced tutorials and soon you'll be an ExcelWriter pro!
{column}
{column:width=30%}
h4. *[Programmer's API Reference]*
Visit the Programmer's API Reference for in-depth knowledge on how a particular object or method works.
{column}
{column:width=30%}
h4. *[Help]*
Need help? We are here for you! You can file a support incident online and we'll get back to you shortly.
{column}
{section}
|
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 |
---|
| |
|
|
|