Docs: SpeedGen: How it Works

SpeedGen uses a powerful Template-Driven, Plug and Play, WYSIWYG Approach. Excel is your Report Designer!

The SpeedGen Approach

1) Design the Source Workbook

Design your Spreadsheet using Microsoft Excel. This is called the Source Workbook. It is any Excel workbook that contains Field Markers. Field Markers specify where data will be inserted.

Open this Sample Source Workbook

2) Create the Code

You can create Spreadsheets in as few as 3 lines of Code

If you would like to change the Excel Workbook, simply edit the Source Workbook with Microsoft Excel.

Modify your Template without modifying your Code!

3) Generate the Output Spreadsheet

Open this Sample Generated Workbook

The Generation of the Spreadsheet is done completely natively, without Microsoft Excel. Furthermore SpeedGen is highly optimized and can write 192,000 cells in under 3 seconds on an 866mhz PIII (16,000 rows x 12 cols of numeric and string data). (* Bottlenecks may occur if your database is slow or the EstimatedSize property is set too low)

Microsoft Excel is NOT required for Generation


(c) 2000-2003 Optimized Software Canada Inc. All Rights Reserved.

Microsoft® Excel is a Registered Trademark of Microsoft Corporation.