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

.NET Support and the CodeWizard

.NET Support

ExcelWriter V4 has added on to the original .NET support with two new methods. The first being the ability to place an ADO.NET DataSet containing a single table into a spreadsheet. And the second allows you to bind a data source to a template spreadsheet that uses data markers to place the database columns you wish into the spreadsheet. This is an improvement over the previous version of ExcelWriter, which required that you move the ADO.NET DataSet into an array and then iterate through the data to place it in the spreadsheet.

The PostOne Financial Corporation is a fictitious company created by SoftArtisans to demonstrate the functionality of SoftArtisans ExcelWriter. The PostOne demonstrations include four complex spreadsheet applications created with SoftArtisans ExcelWriter: Checking account statement, Mortgage calculator, Investment portfolio, and Monthly sales report. These demonstrations give you a real look at what you can accomplish with ExcelWriter. For example, the checking account statement demonstrates the ability of templates to load different data into the same spreadsheet by having you pick a month for your report that contains a chart and a pivot table.


The developer editions of ExcelWriter include an automatic code generator named CodeWizard that creates scripts from existing spreadsheets. The CodeWizard takes a Microsoft Excel spreadsheet and generates ASP, ASP.NET, or Visual Basic code to create an identical spreadsheet.

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:06:35 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search