Docs: SpeedGen: Benefits & Features

Benefits & Features
Microsoft Excel is NOT required for Generation Generate 100% Native Excel 5.0 through 2002 (XP) files (BIFF7, BIFF8 or BIFF7+8 Dual-Stream formats) without Excel Support for the latest Excel formats makes it much easier to use and far more powerful than SpeedGen v1.x Unparalleled Ease-of-Use for both Developers and End-Users Templates Create Spreadsheets in only 3 lines of Code with our Powerful Template-driven approach Excel is your very own WYSIWYG Report Designer Modify Templates without modifying your Code Advanced Template Layout Capabilities Automatic Formula & Range Stretching Ideal for filling out any kind of form Anyone can design or customize Templates. Developers Sales People Customer Support Representatives Customers or anyone else... Excel Features Full UNICODE Support Supports the Entire Excel 5.0 through 2002 format Virtually anything you can do in Excel, you can do with Excel SpeedGen. (All Formulas and Functions, Formatting, Conditional Formatting, Charts, Pictures & Graphics Objects, PivotTables, PivotCharts, VBA & Macros, Named Ranges, AutoFilters, Data Tables, List Boxes, Combo Boxes, Forms & Controls, Outlines, Page Breaks, Repeating Rows & Columns, Print Settings, Frozen Panes, Add-Ins, and much, much more ) Data Handling Aliases completely isolate the Template from any dependence on the structure of the source data. Any ADO or DAO RecordSet, 2D Arrays or even XML Documents can be a RecordSource Combine data from an unlimited number of RecordSources into one Spreadsheet Easily dump any recordsets to Excel. You do not even have to know the names or number of Fields Variables and 1D Arrays can also be used as source data. Standard Field Markers allow for easy Item Numbering and Date Insertion (Today, Tomorrow, Next Work Day, etc.) Insert Data Down or Across the spreadsheet (including wraparound so you are not limited by the 256 columns). Dynamic Formatting Hide Sheets at run-time Clear multiple Cell Ranges at run-time Format multiple Cell Ranges at run-time in either the Source Workbook or Generated Workbook. Rename Sheets at run-time. Interactive Analysis PivotTables PivotCharts AutoFilters Data Tables Form Controls (Combo Boxes, List Boxes, etc.) Performance & Reliability Highly optimized for speed, file size and memory overhead. RecordSet ReadAhead. Read Multiple-Rows at a time. 100% in-memory Creation. No Temporary files are ever created. Scalable solution capable of producing tens of thousands of complex spreadsheets per day for multiple concurrent users. Tests have been performed with over 1 million Generations The Fastest Solution on the Market Writes most files in a few hundred milliseconds Writes 192,000 cells in under 3 seconds on an 866mhz PIII (16,000 rows x 12 cols of numeric and string data) Benchmarks File Size Writes all Excel File Size & Lookup Optimizations Compresses multiple adjacent blank and numeric cell records. For Excel 97 and Greater Compresses Western Language UNICODE strings to half their size. Maintains a Unique String Table so the same string is never physically written more than once. This produces a much smaller file when you have duplicate strings. Documentation & Samples Thorough Documentation ( with Index and fully Searchable ) Step-By-Step Tutorials Over 100 Sample Scripts Comprehensive KnowledgeBase SpeedGen ASP & Desktop Features Click here for Edition-Specific Benefits & Features
Uses
Reports. Spreadsheets are great for Reports. Everyone knows how to use Excel. Analysis. Spreadsheets are interactive. They are great analysis tools. Examples Your Service Reps could design customized Spreadsheet Templates for your Customers, thus freeing your Developers to do other work. Real Estate agents could let visitors to their site download a list of homes they are interested in, including Pictures! (see example ) Bank Customers could download their account history in Excel Format Stock Brokers could allow their customers to download their accounts in native Excel Format. Potential customers could visit your web site and choose the products they are interested in. Then they could download an Excel Workbook containing only what was requested. and much, much more...

Benefits & Features

Microsoft Excel is NOT required for Generation

Generate 100% Native Excel 5.0 through 2002 (XP) files (BIFF7, BIFF8 or BIFF7+8 Dual-Stream formats) without Excel
Support for the latest Excel formats makes it much easier to use and far more powerful than SpeedGen v1.x
Unparalleled Ease-of-Use for both Developers and End-Users
Templates
- Create Spreadsheets in only 3 lines of Code with our Powerful Template-driven approach
- Excel is your very own WYSIWYG Report Designer
- Modify Templates without modifying your Code
- Advanced Template Layout Capabilities
- Automatic Formula & Range Stretching
- Ideal for filling out any kind of form
- Anyone can design or customize Templates.
  - Developers
  - Sales People
  - Customer Support Representatives
  - Customers
  - or anyone else...
Excel Features
- Full UNICODE Support
- Supports the Entire Excel 5.0 through 2002 format
- Virtually anything you can do in Excel, you can do with Excel SpeedGen. (All Formulas and Functions, Formatting, Conditional Formatting, Charts, Pictures & Graphics Objects, PivotTables, PivotCharts, VBA & Macros, Named Ranges, AutoFilters, Data Tables, List Boxes, Combo Boxes, Forms & Controls, Outlines, Page Breaks, Repeating Rows & Columns, Print Settings, Frozen Panes, Add-Ins, and much, much more )
Data Handling
- Aliases completely isolate the Template from any dependence on the structure of the source data.
- Any ADO or DAO RecordSet, 2D Arrays or even XML Documents can be a RecordSource
- Combine data from an unlimited number of RecordSources into one Spreadsheet
- Easily dump any recordsets to Excel. You do not even have to know the names or number of Fields
- Variables and 1D Arrays can also be used as source data.
- Standard Field Markers allow for easy Item Numbering and Date Insertion (Today, Tomorrow, Next Work Day, etc.)
- Insert Data Down or Across the spreadsheet (including wraparound so you are not limited by the 256 columns).
Dynamic Formatting
- Hide Sheets at run-time
- Clear multiple Cell Ranges at run-time
- Format multiple Cell Ranges at run-time in either the Source Workbook or Generated Workbook.
- Rename Sheets at run-time.
Interactive Analysis
- PivotTables
- PivotCharts
- AutoFilters
- Data Tables
- Form Controls (Combo Boxes, List Boxes, etc.)
Performance & Reliability
- Highly optimized for speed, file size and memory overhead.
- RecordSet ReadAhead. Read Multiple-Rows at a time.
- 100% in-memory Creation. No Temporary files are ever created.
- Scalable solution capable of producing tens of thousands of complex spreadsheets per day for multiple concurrent users.
- Tests have been performed with over 1 million Generations
- The Fastest Solution on the Market
  - Writes most files in a few hundred milliseconds
  - Writes 192,000 cells in under 3 seconds on an 866mhz PIII (16,000 rows x 12 cols of numeric and string data)
  - Benchmarks
File Size
- Writes all Excel File Size & Lookup Optimizations
- Compresses multiple adjacent blank and numeric cell records.
- For Excel 97 and Greater
  - Compresses Western Language UNICODE strings to half their size.
  - Maintains a Unique String Table so the same string is never physically written more than once. This produces a much smaller file when you have duplicate strings.
Documentation & Samples
- Thorough Documentation ( with Index and fully Searchable )
- Step-By-Step Tutorials
- Over 100 Sample Scripts
- Comprehensive KnowledgeBase

SpeedGen ASP & Desktop Features

Click here for Edition-Specific Benefits & Features

Uses

Reports. Spreadsheets are great for Reports. Everyone knows how to use Excel.
Analysis. Spreadsheets are interactive. They are great analysis tools.

Examples

Your Service Reps could design customized Spreadsheet Templates for your Customers, thus freeing your Developers to do other work.
Real Estate agents could let visitors to their site download a list of homes they are interested in, including Pictures! (see example )
Bank Customers could download their account history in Excel Format
Stock Brokers could allow their customers to download their accounts in native Excel Format.
Potential customers could visit your web site and choose the products they are interested in. Then they could download an Excel Workbook containing only what was requested.
and much, much more...

Confused? Just ask us

Online Docs Table of Contents

KnowledgeBase

Microsoft® Excel is a Registered Trademark of Microsoft Corporation.