Essential XlsIO : Volume 3 Sneak Preview - [Part 2]

This post is the final part of a two-part series about our forthcoming Volume 3 release.  In my previous post, I discussed a couple of our new features, which are all specific to Excel 2010.  In this post, I will continue to discuss other new features that will be available with our Volume 3 release.

Linked Cells Support for Check Box

All check boxes can be optionally linked to a cell; any operation performed on a check box will update the value of the linked cell, making Excel form programming much easier.  With the Volume 3 release, Essential XlsIO will offer support to both read and write linked cell values associated with the check box.




Sample Excel Form with Check Box and Other Form Controls


Code-Generator Utility

Microsoft Excel offers a huge set of features that include charts, formulas, pivot tables, form controls, and much more. Essential XlsIO offers 80-85 percent of these Excel features; hence, our XlsIO also exposes a huge set of APIs. 

In an attempt to reduce the overall development time and learning curve, in 2010 Volume 3 we plan to introduce a simple and easy-to-use code generator utility.  All you have to do is simply design an Excel file using MS Excel. Then load that Excel file into our code-generator utility. The utility will automatically generate either C# or VB code to create a similar Excel file using Essential XlsIO.




Also, if you click on a particular node in the left-side tree, then code will be generated that can be used to create a specific portion of a document. This really simplifies the process of document generation using XlsIO.