|
|
 |
 OfficeWriter Home > officewriter-61.aspx |
| Getting
Started with OfficeWriter Development |
Usage
Scenarios: |
 |
SoftArtisans OfficeWriter's Template functionality makes it easy to create
reports on the Web. Most of the work can be done in Microsoft Excel or Word,
by any user who knows how to use Microsoft Office, resulting in a significant
reduction in development time and cost. Spreadsheets and documents can contain
charts, graphs, pivot tables and macros. |
| View
common usage scenarios when adding OfficeWriter to your MS Office
reporting and business intelligence applications. click
here |
|
| |
| |
| Step
1: Create Template |
 |
| Create a template spreadsheet
using Microsoft Excel or Word and add datamarkers where the data should
populate your template. The look and feel of the output file can be totally
designed in Excel or Word by anyone with experience in Microsoft Office,
and the datamarkers and OfficeWriter script can be quickly added by a developer. |
| |
 |
| |
| |
| Step
2: Connect to Data Source |
|
| Connect to the data
source in your OfficeWriter script. In as little as four lines of code,
the file can be loaded with data from any combination of recordsets, variables
or arrays. |
| |
 |
| |
| |
| Step
3: Run Reporting Application |
|
| The resulting Excel
or Word file can be presented in the browser window or it can be opened
in Excel or Word on the client machine. It retains all of the formatting,
functions, fonts, charts, pivot tables and VBA of the original template
spreadsheet and is dynamically populated with the data from the data source. |
| |
 |
| |
|
|
|