...
You can download the Hello World sample code (see above) to see the finished product.
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 |
|---|
| | Wiki Markup |
|---|
With ExcelTemplate , we can insert our data into a specially formatted Excel file.
{div5:class=button-style}
[Using ExcelTemplate|Hello World using ExcelTemplate]
{div5}
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 |
|---|
| | Wiki Markup |
|---|
With ExcelApplication's full object-model, we can create an Excel file completely from scratch.
{div5:class=button-style}
[Using ExcelApplication|Hello World Using ExcelApplication]
{div5}
scratch. | Panel |
|---|
| bgColor | #6691BC |
|---|
| borderStyle | solid |
|---|
| borderColor | White |
|---|
| borderWidth | 20 |
|---|
| |
|
|
|
