Spreadsheets in WPF with Absolutely No Excel Dependency
Import and export Microsoft® Excel® workbooks in high-fidelity, with the compiled assembly that reads and writes in the widely-interoperable XLS/XLSX/ExcelML file formats. With absolutely no Excel dependency, your WPF application can run completely independent of Excel, and Excel does not have to be installed alongside your application.
Key Features at a Glance
- Shapes Support - Create and flip simple shape types - such as rectangles, right triangles and line shapes - horizontally or vertically, or change their outline or fill colors.
- Data Validations - Constraints can now be placed on the values entered by users in Microsoft Excel. All data validations, including drop down lists and custom formula validations, are supported.
- Print Titles - Groups of rows and columns can now be set to be repeated on each printed page, when a user prints the worksheet in Microsoft Excel.
- Print Area - Rectangular ranges of cells can now be set to be printed on their own pages, when a user prints the worksheet in Microsoft Excel.
- Page Breaks - Horizontal and vertical page breaks can now be added to the worksheets.
- Absolutely No Excel Dependency – Infragistics.Excel is a compiled assembly that runs completely independently of Microsoft Excel, so you do not require it to be installed.
- 100% Managed, 100% Client Side – This is not a wrapper around native OLE file system libraries!
- Bidirectional File Access- Serialize and deserialize workbooks to and from BIFF8 files (.XLS) that are binary-compatible with Excel 97 and later, the new .XLSX/.XLSM file formats* in Excel 2007 capable of one million row worksheets, and the latest ExcelML file format in Excel 2010.
- Template Files– Reads and writes template files (.XLT) compatible with Excel 97 and later, the new .XLTX/.XLTM file formats* in Excel 2007, and the latest ExcelML file format in Excel 2010, without losing a step.
- Workbook Object Model – Represents the gamut of Excel objects available including Workbooks, Worksheets, Cells, Formulas and many more.
* - Support of Microsoft Excel 2007 .XLSX, .XLTX, .XLSM, and .XLTM file formats requires .NET Framework 3.0, and is only included in builds of the Infragistics.Excel assembly for CLR 3.0 or later.