ASP.NET Samples
    .NET Application Samples
    Reporting Services Samples

    View The Latest
OfficeWriter Docs

    OfficeWriter Home
    OfficeWriter Resources
    OfficeWriter Demos
ExcelApplication Data Validation Demo (C#)

This sample application demonstrates how ExcelApplication can be used to programmatically add Data Validation rules to Excel workbooks.

Technical Overview

Excel Data Validation (in Excel the menu, Data > Validation...) allows you to control what kind of data can be entered into cells by creating validation rules. You can define and apply these rules with ExcelApplication.

Click the "View source" link below to see the code that generates the Excel report for this demo.

View source

Click to run demo

Loan Start Date
Annual Interest Rate
Loan Period
Down Payment %
Borrower Name
Purchase Price





Copyright 2005 © SoftArtisans, Inc. All Rights Reserved.