Moving a Worksheet within an Excel Workbook In certain cases you might need to move a worksheet to a particular index position in the owning Excel® workbook’s worksheets collection. Considering, you have three worksheets in an Excel Workbook, you can place worksheet3 in the first position, using the MoveToIndex me...
Office 2007 XLSX file generation references and dependencies Using .NET CLR 4.0 or greater When using the Infragistics® Excel® object library and exporters to generate a Microsoft® Office® 2007 compliant xlsx Excel File, the .NET Framework CLR version 4.0 or greater is required. In this scenario, you will referenc...
Page Breaks This topic outlines the page break support in the Infragistics Excel Engine and provides a code example demonstrating usage. The topic is organized as follows: Introduction Creating Page Breaks Overview Preview Code Example Related Topics Introduction Infragistics Excel Engine allows you to insert vert...
Populating a Worksheet from a DataSet Before You Begin The main use for a Microsoft® Excel® worksheet is to display data. You can easily transfer data from an existing DataSet to a workbook so you can view it in Excel. A DataSet consists of one or more DataTable objects. Each DataTable can be mapped to a worksheet...
Preserving Table Formatting When Loading Excel Files Topic Overview Purpose This topic demonstrates how you can preserve table formatting when loading Microsoft Excel files. In this topic This topic contains the following sections: Introduction Code Example: Preserving Formatting While Loading Excel Tables Related...
Print Areas This topic outlines the print areas support in the Infragistics Excel Engine and provides a code example demonstrating usage. The topic is organized as follows: Introduction Creating Print Areas Overview Preview Code Example Related Topics Introduction Infragistics Excel Engine allows you to set one or...
Print Titles This topic outlines the print titles support in the Infragistics Excel Engine and provides a code example demonstrating usage. The topic is organized as follows: Introduction Creating Print Titles Overview Code Example Related Topics Introduction Infragistics Excel Engine allows you to designate a con...
Read an Excel 2007 XLSX File Into a Workbook In addition to writing out Microsoft® Excel® files, the Infragistics.Documents.Excel assembly can also read them. When an Excel file is read with the static Load method, a Workbook object is created and its entire object model is populated with all supported information...
Read an Excel File into a Workbook In addition to writing out Microsoft® Excel® files, the Infragistics.Documents.Excel assembly can also read them. You can create a Workbook object from an existing Excel file, make some changes, and save a new file containing the modified workbook. When an Excel file is read with...
Resizing Rows and Columns Before You Begin In a worksheet, you may have a large amount of text in a cell or a large image that you want to appear in a cell. If the default cell size cannot fit the cell’s contents, you can easily increase the height and width of all cells in a row, column, or the entire worksheet. ...