KnowledgeBase
Yes, most of them do. But they usually produce spreadsheets very slowly through automation or they do not adhere exactly to the Excel File format. (Their files can be read by Excel but are not fully optimized to minimize workbook file size and reduce loading times)
Yes! SpeedGen produces 100% Native Excel files, including all file-size optimizations and indexing records.
Most Excel writers/reporters that produce native Excel files do not include all the optimizations and indexing records. There is a good reason for this. These things are extremely complicated to implement. However, lack of these optimizations greatly increases file size and slows down viewing, editing and loading in Excel. Especially when many rows are involved.
Furthermore, keeping file size to a minimum is very useful in a Server environment since memory is always in short supply.
When writing the Excel Excel 97 / 2000 / 2002 (XP) format, SpeedGen maintains a unique string table. So the same string is never written more than once, only it's index is. Western Language Strings are also compressed to half their size. Therefore SpeedGen files can be much smaller than those created by other native Excel report writers that do not implement these optimizations.
With SpeedGen, everything is written just the way Excel would. Fully indexed and optimized.
| Confused? Just ask us | Online
Docs Table of Contents
KnowledgeBase
|
(c) 2000-2003 Optimized Software Canada Inc. All Rights Reserved.
Microsoft® Excel is a Registered Trademark of Microsoft Corporation.