Spreadsheets in Windows Forms with Absolutely No Excel Dependency

Click here to watch the Excel importing and exporting workbooks control video. (Duration: 1:25)

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 Windows Forms application can run completely independent of Excel, and Excel does not have to be installed alongside your application.

Maximize the value your users get out of the information in your Windows® Forms application by making it portable with Microsoft® Excel® 2010 and many other popular spreadsheet applications. Now you can build your data-driven solutions on top of the Infragistics. Excel code library for C# and VB.NET developers, with the interoperability you need to both read and write .XLS, .XLT, .XLSX*, .XLTX*, .XLSM*,.XLTM* and ExcelML files. Your users will appreciate the freedom of working with data in the best environment for the task, such as running "What If?" scenarios in Excel and then importing those calculations back into your application. Collaboration like this produces remarkable returns because we take care of the interoperability, and relieve you of having to build expensive spreadsheet capabilities on your own.

  

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.
  • Extensive Excel Object Model - An intuitive object model designed to mirror the layout, formatting and behavior of Excel spreadsheets including worksheets, formulas, frozen panes, formatted strings and much more.
  • 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.
  • Formulas - Array and Cell Formulas encoded in Excel syntax are written to generated workbooks, and Formulas in Workbooks are resolve as actual formula values.
  • VB Roundtripping - Macros stored in a loaded Workbook are retained and written out undisturbed to the Workbook when saving changes.
  • Image Embedding - Conveniently add worksheet image shapes to the Shapes collection, or set the image background of a worksheet.
  • Custom Views - Create custom views, optionally with display and print options, that restore the user's workspace to a pristine layout when they open a workbook.
  • 100% Managed Code - Functions in partial trust without needing code access security permissions to call unmanaged code for OLE structured storage file access.
* - 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.