ExcelWriter V4 Review
page 3 of 10
by Andrew Mooney
Average Rating: 
Views (Total / Last 10 Days): 49440/ 88

Operation and Features

I found it very easy to create Web reports in the form of spreadsheets in ExcelWriter using just a few lines of code in ASP script. Developers that are familiar with Excel VBA can begin writing advanced spreadsheet reports immediately. You can generate the report data in ASP script or retrieve it from a data source. An interesting note is that the reports created with ExcelWriter are spreadsheets and not Web pages. You cannot add HTML tags or use the Response.WriteLine on the page. However, you can customize your spreadsheet to make it look professional by adding formulas, formatted text, column width and alignment, borders, color and many more options.

With ExcelWriter, you can quickly make new files by inserting values into template spreadsheets. Any experienced Excel user can create the template spreadsheet using Data Markers to place database columns in the desired location for the report. Then a developer only has to add a few lines of code to the template. Utilizing templates can save time by using them to create multiple spreadsheets. Macros can be added to template spreadsheets using VBA script to perform functions in the Excel spreadsheet on the client.

View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2023 ASPAlliance.com  |  Page Processed at 2023-03-23 10:09:52 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search