Applying Styles to Cells Before You Begin The ability to apply styles to cells is one of the ways the Infragistics.Documents.Excel assembly allows you to customize your worksheets. Every aspect of the cell can be customized and each cell can appear differently. You can control the font used in the cell, the call b...
Calculating Order Totals Before You Begin A common task in a Microsoft® Excel® workbook is to store a column or row of numerical data and have a cell containing the total of these numbers. The nice thing about this total is it can automatically update when one of the numbers changes. You can create a total cell in...
Changing the Default Font Topic Overview Purpose This topic describes how to change the default font of a worksheet when exporting to Microsoft Excel®. In this topic This topic contains the following sections: Introduction Code Example: Change Default Font Related Topics Introduction There is a special type of sty...
Comments in a Worksheet Cell Cell Comments are used to explain or remind the content of a cell or range of cells. For example, they may be used to explain the formulas that reside in the cells they are attached to. As in Microsoft® Excel®, it is possible to add cell comments to your Excel Worksheet using the Works...
Conditional Formatting in Infragistics Excel Engine Purpose This topic explains how to configure and set conditional formatting on a Worksheet using the Infragistics Excel Engine. Required Background The following table lists the concepts and topics required as a prerequisite to understanding this topic: Topic Pur...
Create a Workbook Before you can take advantage of the features in the Infragistics Excel Engine, you will need to create a Workbook object. You can do this by either reading an existing Microsoft® Excel® file, as explained in the How Do I… topic: Read an Excel File into a Workbook or you can create a blank workb...
Creating a Predefined Shape This topic demonstrates how to create a predefined shape through the Infragistics Excel Engine. The topic is organized as follows: Requirements Creating a Predefined Shape Preview Code Snippet Related Topics Requirements Infragistics4.Documents.Excel.v18.1 assembly added to your Visual ...
Creating a Workbook in office 2007 XLSX format Infragistics® Excel® object library enables you to create Excel files with the new xlsx format(Excel2007). For more information on project dependencies and references when creating and saving to the xlsx format, please review the topic Office® 2007 xlsx file generatio...
Creating Excel Named Table Code Example Description The code below returns a Workbook object, containing a WorksheetTable named Patients . This table is used in several code examples. Code In Visual Basic: In C#: Related Content Topics The following topics provide additional information related to this topic. Topi...
Data Validation This topic outlines the data validation support in the Infragistics Excel Engine and provides a code example demonstrating usage. The topic is organized as follows: Introduction Data Validation Overview Code Example Related Topics Introduction Data validation is the process of verifying user-entere...