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 Workbook
Adding Shapes to a Worksheet
Adding a Chart to a Worksheet
Adding a Sparkline to a Worksheet
Adding a Hyperlink to a cell in an Excel file
Applying Styles to Cells
Calculating Order Totals
Changing the Default Font
Create a Workbook
Creating a Workbook in office 2007 XLSX format
Creating Excel Named Table Code Example
Comments in a Worksheet Cell
Excel 2007 Color Model
Filtering Exported Tables
Filtering Worksheet Regions
Freeze Rows and Columns
Getting the Value of a Formula from an Excel File
Merge Cells
Moving a Worksheet within an Excel Workbook
Populating a Worksheet from a DataSet
Preserving Table Formatting When Loading Excel Files
Read an Excel File into a Workbook
Read an Excel 2007 XLSX File Into a Workbook
Resizing Rows and Columns
Retrieving the Cell Text as Displayed in Excel (Get Cell Text)
Save and Load Files in Excel Template Format
Sorting Exported Tables
Support for Excel Workbooks with VBA code
Support Named Tables in an Excel Spreadsheet
Write a Workbook to an Excel File