Report creation in Excel will be a major requirement for most of us, as it provides neat and rich look for large set of data. This article focuses on creating an Excel report using Template markers.

Template Marker is a special marker symbol created in an Excel template which will be bound to the data of user's interest.

Essential XlsIO allows creating and binding the markers with data from various sources such as data table, variables and arrays. This will allow the user to control the formats for the data when bound to the template document.

MSExcel's conditional formatting feature offers an easy way to apply special formatting to cells if a particular condition is met. This feature is even more useful when you understand how to use a formula in your conditional formatting specification. For e.g., Conditional formatting can highlight students who scored higher on the second test. This formatting is dynamic; if you change the test scores, the formatting adjusts automatically.

This article focuses on various conditional formatting that can be applied to the range of cells. It also explains how conditional formatting can be copied to another cell, and how large number of rules can be applied with Excel 2007.

Data validation is a feature of Excel that helps to control the kind of information that is entered in the worksheet. It provides users with following options:

• A list of choices
• Restricts entries to a specific type or size
• Create custom settings

This helps you to quickly select an item from the list and move on to the next entry. Essential XlsIO has support for reading and writing data validations. This article focuses on demonstrating how various validations in MS Excel are performed with XlsIO.

Developing secure products are as important as the product itself. Most security measures involve data encryption and passwords. Excel features reporting large confidential date. Hence, security plays main role in report generation. This article focuses on demonstration how an Excel workbook is secured with password encryption and how it is decrypted back using Essential XlsIO.

Encryption is a method of protecting workbook data, based on a password which converts it into the form that can not be understand and restricts the anonymous users from accessing the data in the document. Decryption is the process of converting encrypted data back into its original form, so that data can be read from the workbook.

Excel is a reporting tool to create large reports from various data sources with styles and formats and provides readability and easy manipulations. Hence, often there exists a need to import /export the data to and from Excel sheet. Essential XlsIO provides various methods to import and export data to and from Excel worksheet with styles and reasonable performance.

This article deals with demonstrating various methods and options to import and Export data to and from Excel worksheets.