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 Excel | Adobe® PDF | HTML | CSV |
| Modifiable by users | Yes | No | No | Yes |
| Multi-platform support | Yes | Yes | Yes | Yes |
| Used for Business Intelligence/Decision Support |
Yes | No | No | Moderately |
| Image support | Yes | Yes | Yes | No |
| Dynamic chart support | Yes | No | No | No |
| Upload back to server | Yes | No | No | Yes |
| Can open in browser | Yes | Yes | Yes | Yes |
| Rich formatting | Yes | Yes | Moderately | No |
Top
Copyright © 2003, SoftArtisans, Inc.