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

Frequently Asked Questions
  1. Does ExcelWriter read existing spreadsheets?
  2. Can ExcelWriter modify an existing spreadsheet?
  3. Can ExcelWriter use template spreadsheets?
  4. Can I generate a chart using ExcelWriter?
  5. What versions of Microsoft Excel does ExcelWriter support?
  6. Which Microsoft Excel features are not available in ExcelWriter?
  7. Does ExcelWriter include features that are not available in Microsoft Excel?
  8. What software do I have to have on my server to use ExcelWriter?
  9. Can I include pictures in ExcelWriter generated spreadsheets?
  10. Does ExcelWriter support .NET?
  1. Does ExcelWriter read existing spreadsheets?

    Yes. To read data from an existing spreadsheet, use the method GetDataFromExcelSheet, or open the file using ExcelApplication.Open.

  2. Can ExcelWriter modify an existing spreadsheet?

    Yes. See Modifying an Existing Spreadsheet.

  3. Can ExcelWriter use template spreadsheets?

    Yes. See Using Template Spreadsheets.

    Note: An ExcelWriter template is a file created in Microsoft Excel that contains data markers and can be opened with the ExcelTemplate object. In the ExcelWriter documentation, the term "template" refers to an ExcelWriter template, not a Microsoft Excel template (.xlt). However, ExcelWriter can open and generate both .xls and .xlt files. Use an .xlt file the same way you would an .xls file.

  4. Can I generate a chart using ExcelWriter?

    Yes. Use the method Charts.Add to generate a chart. ExcelWriter offers over forty chart styles (see Chart Codes). ExcelWriter's numerous charting properties allow you to customize every detail of your chart.

  5. What versions of Microsoft Excel does ExcelWriter support?

    ExcelWriter can produce either Excel 97/2000/XP (BIFF8) format files or Excel 95 (BIFF7) format files. Not all features are supported by Excel 95.

    Note: The ExcelTemplate object supports Excel's BIFF8 (Excel 97/2000/XP) format only; ExcelTemplate does not support BIFF7 (Excel 95) format templates, and will not generate BIFF7 format files.

  6. Which Microsoft Excel features are not available in ExcelWriter?

    We are constantly adding new features to ExcelWriter. If there is a particular Microsoft Excel feature currently unavailable in ExcelWriter that you would like to use, please let us know by sending an email to info@softartisans.com.

    • The ExcelApplication object and the ExcelTemplate cannot create certain Excel features such as Pivot Tables, Macros and VBA (Visual Basic for Applications). However, ExcelWriter will preserve all Excel features when opening an existing spreadsheet.

      Creating a file in Microsoft Excel, and then using that XLS file as input to ExcelWriter allows you to use any Excel feature. ExcelWriter will apply changes in memory to the XLS file, such as by merging against a database or changing formatting. The modified file can be streamed to the user's browser, saved as a new file, or saved over the original file. See Modifying an Existing Spreadsheet and Using Templates.

    • ExcelWriter cannot create a hyperlink to a different workbook.

  7. Does ExcelWriter include features that are not available in Microsoft Excel?

    Yes, ExcelWriter includes the following features, unavailable in Microsoft Excel:



  8. What software do I have to have on my server to use ExcelWriter?

    • Windows 2000 or Windows NT 4.0
    • Any COM client including Active Server Pages, Visual Basic, etc.
    • If you intend to create spreadsheets from databases, install the latest Microsoft drivers. The driver package is available for free for all versions of IIS at http://www.microsoft.com/data. Choose to download MDAC 2.0 or later. MDAC includes updates to ADO, OLEDB, and related ODBC drivers.
    • Please see the README.HTM for the latest compatibility information.


  9. Can I include pictures in ExcelWriter generated spreadsheets?

    Yes. To add a picture to your spreadsheet, use Pictures.CreateFromFile.

  10. Does ExcelWriter support .NET?

    Yes. See Using ExcelWriter From A .NET Application.

Copyright © 2003, SoftArtisans, Inc.