Forums     Knowledge Base     OfficeWriter Online     
This documentation is for
OfficeWriter v3.9.2
.NET Platform

View Docs for Another
Version or Platform

Introduction > What is ExcelWriter?

What is ExcelWriter?

SoftArtisans ExcelWriter is a high-performance pure .NET solution that generates native Microsoft Excel spreadsheets on a Web server. A few simple lines of code generate editable presentation-quality spreadsheets that can be saved on the server or viewed instantly by thousands of concurrent users.

The spreadsheets generated by ExcelWriter are in native Microsoft Excel format (.xls) and preserve all of the familiar features associated with Excel workbooks. ExcelWriter offers high-speed performance and, since Microsoft Excel is not required on the Web server running ExcelWriter, your Web applications have licensing flexibility and ease of deployment.

Using ExcelWriter, you can generate a workbook from an existing Excel file, an ExcelWriter template, or from code:

Using a Template

Maximum Speed

To generate spreadsheets with the greatest speed:
  1. In Microsoft Excel, create a template file containing data markers that will bind to one or more data sources.
  2. In code, use ExcelWriter to open the template, set data sources, populate data markers, and save the file, stream it to the client, or both.
Using an Existing Spreadsheet

Increased Flexibility

When you modify an existing spreadsheet using ExcelWriter code, all Excel features and functionality are preserved in the newly generated spreadsheet. You can easily enhance spreadsheets, at runtime, with ExcelWriter's extensive design and charting capabilities.
Pure Coding

Completely Dynamic

This dynamic approach provides total control, at runtime, of every element in the resulting spreadsheet.

What ExcelWriter is Not

ExcelWriter is not a visual end-user tool like Microsoft Excel. It is not an ActiveX control that exists on the client. Rather, it generates native Excel files via server-side scripting that can be read by Microsoft Excel.

ExcelWriter does not use XML or HTML to represent the spreadsheet. The resultant spreadsheet is in the native Microsoft binary format (BIFF8). This permits the creation of rich spreadsheets, including charts and images, and allows for support of all versions of Excel from Excel 95 through Excel XP.

ExcelWriter does not have a calculation engine to perform computation on the cells in the spreadsheet. When formulas are included in a spreadsheet, Excel calculates the values when it loads the spreadsheet. (Please note: since ExcelWriter does not calculate values, evaluation of formulas is not possible during spreadsheet creation).

ExcelWriter does not produce static charts in GIF or JPG/JPEG image format. Rather, it produces fully dynamic 2D or 3D Excel charts capable of referencing data in any worksheet in the workbook that contains the charts.

Copyright 2007 © SoftArtisans, Inc. All Rights Reserved.