Getting Started with
OfficeWriter Development
|
 |
|
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.
|
|
| 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. |
Template Created in Excel (without data)
| 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. |
OfficeWriter Code
| 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. |
Resulting Excel Spreadsheet Opened in Browser Window
|
