Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can download the code for the hello world Hello World tutorial as a visual studio Visual Studio solution.

ExcelWriter Reference in Visual Studio

...

  1. Open Visual Studio and create a .NET project (this tutorial .
    • The ExcelWriter Hello World sample code uses a web application
    )
    • .
  2. 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 (C# or VBsee 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
width50%
Panel
bgColorwhite
titleBGColor#EEE
titleHello World: Template Based Approach
borderColor#AAA
titleColor#666

With ExcelTemplate , we can insert our data into a specially formatted excel Excel file.

Column
width50%
whitetitleBGColor#EEE#AAAtitleColor
Panel
bgColor
#6691BC
borderStyle
solid
titleProgramatic Approach
borderColor
White
borderWidth
#666

With ExcelApplication's full object-model, we can create an excel file completely from scratch.

Hello World Using ExcelApplication

Section
20

 Using ExcelTemplate

Column
width50%
With ExcelTemplate, we can insert our data into a specially formatted excel file. {div5:class=button-style} [Using ExcelTemplate| World using ExcelTemplate] {div5}
Panel
Panel
bgColorwhite
titleBGColor#EEE
titleTemplate Based Approach
borderColor#AAA
titleColor#666
Wiki Markup
Hello
Column
width50%

With

ExcelApplication's

full

object-model,

we

can

create

an

excel

Excel file

completely

from

scratch. {div5:class=button-style} [Using ExcelApplication|Hello World Using ExcelApplication] {div5}

scratch.

bgColorwhite
titleBGColor#EEE
titleProgramatic World: Programmatic Approach
borderColor#AAA
titleColor#666
Wiki Markup
Panel
bgColor#6691BC
borderStylesolid
borderColorWhite
borderWidth20

  Using ExcelApplication