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

The Web Reporting Solution


SoftArtisans ExcelWriter: The Power of Microsoft® Excel on the Web

SoftArtisans ExcelWriter is a scalable, cost-effective, and efficient solution for producing online query and reporting applications in the format that end-users prefer: Microsoft Excel. ExcelWriter is a server-side product that accelerates the development and deployment of native Excel Web applications. It produces richly formatted, full-function Excel workbooks on-the-fly for an unlimited amount of concurrent end-users, without installing Microsoft Excel on the server. With SoftArtisans ExcelWriter, online applications and intranet portals seamlessly integrate with common desktop applications.

Applications created with ExcelWriter make a dramatic impact on the distribution of information across an enterprise. ExcelWriter can save time and effort for both application developers and end users. Users are accustomed to quantitative reports in full-function, richly formatted Excel on their desktop. SoftArtisans ExcelWriter means that standard Excel documents do not have to be compromised into HTML, flat CSV files, or un-editable PDF files to be quickly served through the Web. ExcelWriter produces real, native Excel — not Excel look-alikes. A simple yet comprehensive solution, ExcelWriter can use dynamic data from a database, ADO recordset, or an existing spreadsheet. ExcelWriter enables a wide range of businesses to create high-performance applications while making efficient use of limited systems, development resources, and users' Excel proficiency.


Benefits

The benefits of using SoftArtisans ExcelWriter for online reporting include:

  • Familiarity of Client
    Microsoft Excel is the most widely used spreadsheet application currently available to work with quantitative data. The widespread familiarity with Excel prevents the need for comprehensive training on a Web reporting software package.


  • Richness
    ExcelWriter delivers richly formatted native Excel files that contain comprehensive formatting, formulas, custom styles, charting, images, and the ability to precisely control page layout, set page breaks, and format print options.


  • Ease of Modification
    Once received on the client machine, the spreadsheets can be manipulated, sorted, and modified as required. Alternatively, these Excel files can be secured and protected, client-side, to avoid tampering or unauthorized access.


  • Upload Back to the Server
    Excel files that have been modified client-side, can be uploaded back to the Web server and read with Cells.GetDataFromExcelSheet, or modified with ExcelAppObj.Open.


  • Flexibility
    Users can serve themselves data and generate Excel reports from any location that has Internet access.


  • Delivery Speed
    Concurrent users receive Excel reports faster, when they need them, without straining the Web server or their patience.


  • Productivity
    Business administration can become more automated. Custom reports for different departments/regions can be automated, reducing dependency on the IT department.


  • Data Visualization and Analysis
    Native Excel charting (2D & 3D) makes data easy to understand.


  • Consistency
    Same data and formatting in reports across the corporation - frequently accessed reports can be saved on the server.


  • Ease of Use
    ExcelWriter makes Web reports accessible to all end users, not just specially trained power users. Most business people are familiar and proficient in using Microsoft Excel as compared to other Web reporting tools.


  • Time Management
    Reporting via the Web reduces and eliminates meetings, conference calls, and many customer service issues.

Top


Web Reporting Format Comparison

Microsoft ExcelAdobe® PDFHTMLCSV
Modifiable by usersYesNoNoYes
Multi-platform supportYesYesYesYes
Used for Business Intelligence/Decision Support YesNoNoModerately
Image supportYesYesYesNo
Dynamic chart supportYesNoNoNo
Upload back to serverYesNoNoYes
Can open in browserYesYesYesYes
Rich formattingYesYesModeratelyNo

Top


Copyright © 2003, SoftArtisans, Inc.