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

Installing SoftArtisans ExcelWriter


Automatic Installation

Double-click ExcelWriter.exe, and follow the Microsoft Installer (MSI) instructions. Automatic installation will,

  • Unpack ExcelWriter files to c:\program files\softartisans\ExcelWriter, or a location you selected during installation
  • Register saexcel.dll
  • Create a virtual directory called ExcelWriter, containing documentation and samples

Top


Upgrading from Another Version

Before installing a new version of ExcelWriter, remove the old version. If ExcelWriter was installed with the auto installer, use the Windows program "Add/Remove Programs" to unregister and remove ExcelWriter and all of its associated documentation and samples. If saexcel.dll was copied to the server and manually registered with REGSVR32, unregister the dll prior to removing it; at the command prompt enter "regsvr32 path\saexcel.dll /u".

Top


Manual Installation

To manually install ExcelWriter, you must first run the automatic installation (described above) to unpack the files. Once the files are unpacked, if you move ExcelWriter to a new server, you can run either the automatic or manual installation.

  1. Copy saexcel.dll to any stable directory on your web server. For example, to copy saexcel to c:\winnt\system32\inetsrv, at the command prompt, type,
    "copy saexcel.dll c:\winnt\system32\inetsrv"

  2. Manually register saexcel.dll, as follows.

    1. To stop the web server, open a DOS window, and enter,
      "net stop iisadmin /y"


    2. To register saexcel.dll, enter,
      "regsvr32 path\saexcel.dll"


    3. To restart the web server, enter,
      "net start w3svc"


    4. Optional: If you want to restart FTP and SMTP services, use the following commands.
      "net start msftpsvc"
      "net start smtpsvc"

  3. The ExcelWriter documentation is available online at http://demo.softartisans.com/Excelwriter/default.asp. To install the documentation on your machine, create a virtual directory called ExcelWriter, and map it to the Doc-Samples directory, as follows.

    1. Open the Internet Services Manager.
    2. Right-click Default Web Site.
    3. Select New -> Virtual Directory. The Virtual Directory Creation Wizard will open.
    4. Click Next.
    5. Enter ExcelWriter as the alias for your virtual directory, and click Next. Note: You may use a different alias, but you will need to change the contents of the global.asa file. To do this, Open doc-samples\global.asa, and change
      		Application("vroot") = "/ExcelWriter/"
      		
      to,
      		Application("vroot") = "/YourAlias/"
      		
    6. Browse to ExcelWriter's Doc-Samples directory and click next. Unless you selected a different directory during installation, you will find Doc-Samples in C:\Program Files\Software Artisans\ExcelWriter.
    7. Check Read, Run, and Browse, and click next.
    8. Click Finish.


Top


Copyright © 2003, SoftArtisans, Inc.