Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
{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|EW8:Installation] for instructions.{info} 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
Wiki Markup
Note
iconfalse
titlePrerequisites

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.

  1. Open Visual Studio and create a .NET project.
    • 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 (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
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 file.

Panel
bgColor#6691BC
borderStylesolid
borderColorWhite
borderWidth20

 Using ExcelTemplate

Column
width50%
Panel
bgColorwhite
titleBGColor#EEE
titleHello 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
borderStylesolid
borderColorWhite
borderWidth20

  Using ExcelApplication