WPF Infragistics.Excel Library

Maximize the value your users get out of the information in your Windows® Presentation Foundation (WPF) application by making it portable with Microsoft® Excel® and many other popular spreadsheet applications. Now you can build your data-driven solutions on top of the Infragistics.Excel class library for C# and VB.NET, with the interoperability you need to both read and write .XLS, .XLSX and .XLSM files. Your users can produce remarkable returns and collaborate by sharing the widely-interoperable Excel workbooks from your application across the organization.

 

Absolutely No Excel Dependency

Infragistics.Excel runs completely independently of Excel, and does not require Excel to be installed alongside your WPF application. Say "Goodbye" to the costly overhead of deploying Excel alongside your WPF application as you might incur with a traditional Excel Automation solution.

 

Foundation for xamDataPresenter™ Import and Export

With DataPresenterExcelExporter™ it's easy to let your users work with and share grid data outside of your xamDataPresenter™ application. One method call exports into a Workbook, and you can then leverage the Infragistics.Excel class library to handle advanced formatting and layout like embedding graphics. Get roundtrip data portability when you use Infragistics.Excel to read data from a Workbook back into your xamDataPresenter.

 

Features at a Glance

  • 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, and the new .XLSX/.XLSM file formats in Excel 2007 capable of one million row worksheets.
  • VB Roundtripping - Macros stored in a loaded Workbook are retained and written out undisturbed to the Workbook when saving changes.
  • Image Embedding - Add worksheet image shapes to the Shapes collection easily, 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.