GreyTrout Software, Inc.
  About Us Search Products
  Support Download Store

SpreadScript 1.2.1

SpreadScript 1.2.1 provides Perl, Python, and Tcl with a spreadsheet calculation engine that includes the capability to read and write native Microsoft Excel™ (XLS) spreadsheet files on Linux and Solaris!
SpreadScript provides the solution!

Click here to download SpreadScript and get a free 30-day evaluation license!

If you have questions, comments, or problems, please send us email at spreadscript@greytrout.com.

Overview

SpreadScript provides a powerful spreadsheet engine for the Perl, Python and Tcl scripting languages. SpreadScript combines the speed of a C library implementation with the convenience of a high-level scripting API. This combination provides scripting languages with a fast, powerful spreadsheet calculation engine without the bulk and overhead of a GUI application.

Since SpreadScript is a complete spreadsheet calculation engine, sophisticated computations in scripting languages are no more complex than simply building a spreadsheet. Complex formula-based calculations are handled by the spreadsheet engine rather than many lines of tedious and error-prone code. Spreadsheet files can be used as templates to drive applications, providing the ability for business users to define and change applications simply by editing the spreadsheet on which the application is based.

SpreadScript allows Linux and Solaris platforms to generate Excel files, giving you the ability to dynamically create spreadsheets from databases, web sites, web forms, and more. Provide dynamically-generated Excel files for download from a web site or automatically email them to customers using standard email file attachments.

Note: SpreadScript can also be used directly from C. Let us know if you are interested in using the C API.

Documentation

The latest manuals and API documentation are in the "doc" subdirectory in the distribution. There is a 350-page SpreadScript User's Guide in PDF, an HTML version of the SpreadScript User's Guide, and a single-page HTML API reference for each language (Perl API, Python API, Tcl API). The documentation for the formula syntax and spreadsheet functions used by SpreadScript is included in the distribution.

There are sample scripts in the "samples" subdirectory. The "simple.*" scripts accomplish the same task in Perl, Python, and Tcl. Those scripts differ only in syntax and are the fastest way to become familiar with how to use SpreadScript. There are additional scripts demonstrating how to convert comma-separated values (CSV) files to Excel files and how to convert an Excel file into HTML.

Live Demo Web Applications

The following demo applications show some of the possibilities of using SpreadScript.

The Spreadsheet Web App is a CGI script written in Python that allows the user to create a spreadsheet using only HTML forms. The user is able to download the spreadsheet in Excel, NExS, and CSV formats. Note that only a small fraction of the code implements the spreadsheet functionality, with the rest handling all of the HTML and CGI duties.

The Stock Quote Data App is a CGI script written in Tcl. It dynamically generates native Microsoft Excel files using the data retrieved from a Yahoo Finance stock quote web page.

Simple Example Scripts

The following scripts demonstrate how to use SpreadScript in each of the scripting languages. Other than the scripting language, the scripts are identical. These scripts are inluded in the "samples" directory of the distribution.

Pricing

The Development License is $195 per developer and is for development only (not production or deployment use). Both the Evaluation License and the Development License cause SpreadScript to insert a "Created with SpreadScript" worksheet in each Excel workbook.

Please contact us for Deployment License pricing.

To purchase a license please send us email at spreadscript@greytrout.com.

Changes from SpreadScript 1.2 to 1.2.1.

The following is a list of enhancements and fixes in SpreadScript 1.2.1.

Changes from SpreadScript 1.1 to 1.2.

The following is a list of enhancements and fixes in SpreadScript 1.2.

Changes from SpreadScript 1.0 to 1.1

The following is a list of enhancements and fixes in SpreadScript 1.1.

Microsoft and Excel are trademarks of Microsoft Corporation. All other trademarks are the properties of their respective owners.

© 1999-2003 GreyTrout Software, Inc. All Rights Reserved