Ignite UI Spreadsheet
The most powerful feature of any spreadsheet is the ability to create formulas based on the spreadsheets data. The Spreadsheet component includes a formula bar that allows users to see formula definitions. The Spreadsheet component supports custom formulas and provides dozens of built-in functions, including simple formulas such as SUM, MEAN, and MEDIAN, in addition to more complex formulas such as GEOMEAN and HARMEAN. The Formula Bar is also resizable, making it easier to see long or complex formulas.
The Spreadsheet component provides many options to manage how users work with and consume the data presented to them. You can programmatically hide the gridlines, headings, and the formula bar. The spreadsheet also supports zooming and text formatting (bold, italics, underline). These features work in real-time, so your users can change these settings on the fly. Users can also split the spreadsheet into scrollable panes and freeze the first column or row.View Sample
Import and Save Data to Excel