Retrieving the Cell Text as Displayed in Excel (Infragistics Excel Engine) Topic Overview Purpose This topic describes how to determine the text that would be displayed in Microsoft Excel® cell given the cell’s value, format string, column width, and worksheet options. You can determine the cell text using the Wor...
Save and Load Files in Excel Template Format The Infragistics Excel library enables you to define template files in three file formats. The three template formats are the Excel Template format (with extension XLTX), the Excel Macro-Enabled Template format (with extension XLTM), and the Excel 97-2003 Template forma...
Sorting Tables Topic Overview Purpose This topic describes how to sort columns in tables. Columns in a table can be sorted by applying a sort condition to the WorksheetTableColumns SortCondition property. In this topic This topic contains the following sections: Introduction Code Examples Overview Code Example: Or...
Support for Excel Workbooks with VBA code Using the Infragistics Excel Engine™, you may want to load and save Microsoft® Excel® Workbooks that have existing VBA macro code embedded in them. It is now possible to round-trip VBA code from both Excel97-2003 and Excel2007 loaded Workbooks, when they are saved out agai...
Supporting Named Tables in a Worksheet Topic Overview Purpose This topic describes table support in Infragistics Excel Engine. In this topic This topic contains the following sections: Introduction Main Features Features overview Accessing tables Creating tables Table styles Table columns Related Content Introduct...
Supported Versions of Microsoft Excel The Infragistics Excel Engine™ is capable of saving and reading Microsoft® Excel® .xls files. These .xls files are saved in a BIFF8 format, and are therefore compatible only with specific versions of Excel. The following table lists the supported versions of Excel and any rest...
Understanding the Infragistics Excel Engine This is a great place for you to start learning about the Infragistics Excel Engine™, and its key features and functionalities. The topics in this section will give you a better idea of why you would want to use the Excel Engine in your applications. Click the links belo...
Using Predefined Shapes This topic outlines the support of shapes for the Infragistics Excel Engine and provides a code snippet demonstrating usage. This topic is organized as follows: Introduction Supported Shape Types Supported Customizations for Shapes Related Topics Introduction Microsoft Excel allows a user t...
Using the Infragistics Excel Engine In this section, you’ll find tutorials that walk you through common scenarios when using the Infragistics Excel Engine™. Accessing Cells and Cell Regions by Name Accessing Cells and Regions by their Reference Strings Add an Image to a Worksheet Add Document Properties to a Workb...
Sorting Worksheet in Infragistics Excel Engine Topic Overview Purpose This topic explains how to configure and perform worksheet level sorting. Required Background The following table lists the concepts and topics required as a prerequisite to understanding this topic: Topic Purpose Infragistics Excel Engine In th...