Introduction
  Welcome
  The Web Reporting Solution
  What is ExcelWriter?
  Features and Benefits
  New in This Version  V4
  Requirements
  Edition Differences
  Frequently Asked Questions
  Troubleshooting

Quick Start
  Creating Your First Spreadsheet
  Adding a Formula
  Adding Formatting
  Importing from a Database

Features In Depth
  Addressing Cells
  Setting Values
  Output Options
  Adding Charts
  Reading an Existing Spreadsheet
  Modifying an Existing Spreadsheet
  The Range Object
  Template Spreadsheets
  How to Use Templates
  ExcelApp.Open vs. ExcelTemplate
  Using ExcelTemplate with PivotTables
  Templates and Charts
  Reliable Spreadsheet Download  V4
  Page Setup
  Formatting Headers & Footers
  Protecting your Worksheet
  Multilingual Support  V4
  XML Import

HotCell Technology  V4
  What is HotCell Technology?
  Upload Example
  Advanced POST Example
  Advanced Upload Example

Programmer's Reference
  Object Model
      ExcelTemplate Object
      ExcelApplication Object
         3DProperties Object
         Area Object
         Axis Object
         Cells Object
         Cell Object
         Charts Object
         Chart Object
         ChartFrame Object
         Font Object
         Line Object
         PageSetup Object
         Pictures Object
         Picture Object
         Range Object
         SeriesCollection Object
         Series Object
         Style Object
         Worksheets Object
         Worksheet Object
  Formula Functions
  Formula Calculation Operators
  Formatting Codes
  Chart Codes

Installation
  Quick Installation
  Configuring IIS
  Security Considerations

External Links
  ExcelWriter Home Page
  Technical Support
  ExcelWriter Demos
  SoftArtisans Home Page
  E-mail General Questions
  E-mail Technical Support
  Legal Information

ExcelWriter Editions


ExcelWriter Editions

All SoftArtisans products come with a 30 day money back guarantee, unlimited free technical support (on an as available basis) and free upgrades to all minor releases. Paid support with guaranteed response time is also available at an additional cost. For more information, including pricing, please visit the SoftArtisans web site.

  • ExcelWriterEE for enterprise class web sites requiring maximum functionality and volume.

  • ExcelWriterEE Developer offers the same functionality as ExcelWriterEE, but generates only one spreadsheet at a time, which is the typical development environment. ExcelWriterEE Developer cannot be used on a production server.

  • ExcelWriterSE is the standard edition of ExcelWriter for high-volume Web applications with minimal Excel formatting, functions, and charting. There is no limit to the number of spreadsheets ExcelWriterSE can generate.

  • ExcelWriterLE is the limited edition of ExcelWriter for Web applications with minimal Excel formatting, functions, and charting. Limited to 200 workbooks per day.

  • ExcelWriterSE/LE Developer offers the same functionality as ExcelWriterSE and ExcelWriterLE, but generates only one spreadsheet at a time, which is the typical development environment. ExcelWriterSE/LE Developer cannot be used on a production server.

  • ExcelWriter Desktop
  • for generating Excel format spreadsheets from your desktop applications.

  • ExcelWriterFree provides the same functionality as ExcelWriterLE but every spreadsheet contains a worksheet that advertises the paid versions and has a limit of 500 rows per worksheet.

What is the Difference Between ExcelWriterSE and ExcelWriterLE?

ExcelWriterSE and ExcelWriterLE offer the same set of features, but while ExcelWriterSE can generate an unlimited number of spreadsheets per day, ExcelWriterLE can generate only 200 spreadsheets per day.

Top


Licensing

  • ExcelWriterEE Licensing
    Licensing is per CPU. A license is required for each CPU where ExcelWriter is installed. There are no per user, per IP address, per Web site, or per server licenses. The ExcelWriterEE license does not allow redistribution of ExcelWriter.

  • ExcelWriterEE Developer Licensing
    Licensing is per development server (not per developer). A developer license is required for every development server where ExcelWriter is installed. The developer license does not allow redistribution of ExcelWriter.

  • ExcelWriterSE Licensing
    Licensing is per server. A license is required for each server - with up to two CPUs - where ExcelWriterSE is installed. There are no per user, per IP address, or per Web site licenses. The ExcelWriterSE license does not allow redistribution of ExcelWriter.

  • ExcelWriterLE Licensing
    Licensing is per server. There are no per user, per IP address, or per Web site licenses. The ExcelWriterLE does not allow redistribution of ExcelWriter.

  • ExcelWriterSE/LE Developer Licensing
    Licensing is per development server (not per developer). A developer license is required for every development server where ExcelWriter is installed. The developer license does not allow redistribution of ExcelWriter.

  • ExcelWriter Desktop Licensing
    Licensing is per developer with no run-time royalties. ExcelWriter Desktop cannot be used within a Windows NT/2000 Service or within an MTS/COM+ Library or Server package. ExcelWriter Desktop includes a redistributable version of saexcel.dll, that you can distribute with your desktop application. For general terms that apply to compiled programs and redistributables, see the ExcelWriter Desktop license agreement.

Top


Compare ExcelWriter Editions

 
ExcelWriter
ExcelWriterSE
ExcelWriterLE
ExcelWriterSE/LE
Developer
ExcelWriter Free
Server Developer
Licensing Per CPU Per
development
server
Per server Per server Per
development
server
Free, no redistribution
OS Required Server Only Professional/
WorkStation
or Server
Server Only Server Only Professional/
WorkStation
or Server
Server Only
Easy Database Import Yes Yes Yes Yes Yes Yes
Templates Yes Yes Yes Yes Yes Yes
Max rows: 500
Cell Formatting Unlimited Unlimited Font type,
style,
size,
and color;
cell borders,
alignment,
background
Font type,
style,
size,
and color;
cell borders,
alignment,
background
Font type,
style,
size,
and color;
cell borders,
alignment,
background
Font type,
style,
size,
and color;
cell borders,
alignment,
background
Excel Functions Over 50,
more to come
Over 50,
more to come
Sum,
Average
Sum,
Average
Sum,
Average
Sum,
Average
Numeric Formatting Yes Yes Yes Yes Yes Yes
HotCell Technology Yes Yes HotCell
POST
only
HotCell
POST
only
HotCell
POST
only
HotCell
POST
only
Max Cell Length Biff7: 255

Biff8: 32000
Biff7: 255

Biff8: 32000
Biff7: 255

Biff8: 32000
Biff7: 255

Biff8: 32000
Biff7: 255

Biff8: 32000
Biff7: 255

Biff8: 32000
Max Number of Rows Biff7: 16384

Biff8: 65536
Biff7: 16384

Biff8: 65536
Biff7: 16384

Biff8: 65536
Biff7: 16384

Biff8: 65536
Biff7: 16384

Biff8: 65536
500
Max Number of Columns 256 256 256 256 256 256
Max spreadsheets generated per 24 hour period Unlimited Unlimited Unlimited 200* Unlimited 200*
Number of concurrent spreadsheets that can be generated Unlimited 1 Unlimited Unlimited 1 Unlimited
Charting Yes Yes Bar,
column,
pie
Bar,
column,
pie
Bar,
column,
pie
Bar,
column,
pie
Pictures Yes Yes No No No No
Worksheets contain Ad No  No  No  No No Yes 

* ExcelWriterLE and ExcelWriter Free will fail when generating more than 200 spreadsheets within 24 hours. Generated spreadsheets can be streamed to the browser or saved in static files on the hard disk. Static spreadsheets can be served an unlimited number of times. Only the generation of new spreadsheets is limited.

Top


Copyright © 2003, SoftArtisans, Inc.