Spreadsheets in ASP.NET 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 file format. With absolutely no Excel dependency, your Web applications can run completely independent of Excel, and Excel does not have to be installed.

 

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 can be included in generated workbooks.
  • 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 or later.