Deploying the Infragistics Excel Engine When deploying a .NET application, you must distribute certain files in addition to your executable. If your application contains one or more Infragistics elements, you will have to distribute or deploy one or more Infragistics assembly files as part of your application. Thi...
Excel 2007 Color Model (Infragistics Excel Engine) Topic Overview Purpose This topic explains how to set colors on various cells format properties. In this topic This topic contains the following sections: Main Features Features Overview Workbook palette Filling a cell Specifying a Color Overview Tint Theme Colors...
Excel Format Support (Infragistics Excel Engine) Topic Overview Purpose This topic explains Infragistics Excel Engine support for cell formats. In this topic This topic contains the following sections: Main Features Features Overview Accessing built-in styles Parent styles Format options Excel Style mimicked behav...
Excel Object Model Workbook The root of the Infragistics.Documents.Excel assembly is the Workbook object. Without a Workbook instance, no other information can be written out as a Microsoft® Excel® file. A workbook contains a collection of worksheets, and each worksheet holds a grid of data in cells. In addition, ...
Filtering Tables Topic Overview Purpose This topic describes how to filter columns in tables. In this topic This topic contains the following sections: Introduction Code Examples Overview Code Example: Average Filtering Code Example: Custom Filtering Code Example: Date Period Filtering Code Example: Fill Filtering...
Filtering Worksheet Regions (Infragistics Excel Engine) Topic Overview Purpose This topic describes how to filter a worksheet region column, set through the FilterSettings property. In this topic This topic contains the following sections: Introduction Code Examples Overview Code Example: Average Filtering Code Ex...
Freeze Rows and Columns Certain data on a worksheet should always remain in view (e.g., column headers and the primary field in a row). For this data, you can freeze rows at the top or columns at the left of a worksheet. When you freeze rows in a worksheet and scroll the worksheet vertically, those rows remain fix...
Getting the Value of a Formula from an Excel File In order to get the evaluated value of an Excel Cell that is represented by a Formula, you simply access the Value property of the WorksheetCell . The example code below shows you how to access a particular Excel Worksheet Cell that is populated by an Excel Formula...
List of Supported Built-in Functions (Infragistics Excel Engine) In this topic This topic contains the following sections: Introduction Supported Excel Functions Unsupported Excel Functions Introduction This document enumerates all supported and unsupported functions by the Infragistics Excel Engine. Supported Exc...
Merge Cells Aside from setting the value or format of cells, you can also merge cells to make two or more cells appear as one. If you merge cells, they must be in a rectangular region. When part of a merged region, each cell in the region will have the same value and cell format; also, they will all be associated ...