Page History

{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. Hello World with ExcelTemplate

ExcelWriter's ExcelTemplate approach allows you to write data to a template file that contains data markers. The data markers tell ExcelWriter where to bind specific sets of data. This tutorial will show you the basics on how to dynamically insert data into a worksheet using ExcelTemplate. 

h5. Setting up the template file

In the template file there is a single data marker {{%%=$DataValue}}. All ExcelWriter data markers are prefaced with {{%%=}} and the {{$}} sign means that the data source for this data marker is 1-dimensional (e.g. 1-dimensional array or single value). {{DataValue}} is the data marker ID we'll  use to bind the data to this data marker. 

New to data markers? Check out our [data markers guide]. 

SCREEN SHOT 

The template file for Hello, World can be found under *{{\templates\Hello World.xlsx}}*.  


h5. Writing the code


h3. Hello World with ExcelApplication

h3. Next Steps

*[Tutorials]*
{excerpt-include:Tutorials|nopanel=true}

*[API Reference]*
{excerpt-include:Programmer's API Reference|nopanel=true}

*[Help]*
{excerpt-include:Help|nopanel=true}

{div}