|
Automate Excel Report generation, deliver rich Windows Forms spreadsheet functionality, populate DataGrids and perform high performance
Excel compatible calculations without Excel. |
Excel Reporting |
|
Easily create richly formatted Excel reports without Excel |
 |
With the wide adoption of Microsoft Excel in so many business settings, there is
no substitute for taking advantage of what spreadsheets have to offer. With SpreadsheetGear
for .NET, your Windows and ASP.NET applications instantly gain the ability to create,
read, modify, calculate and write Excel workbooks without Excel. With our extensive API, you can
quickly deliver richly formatted interactive Excel reports which your users already
know how to use. |
Windows Forms
Spreadsheet Control Samples |
|
Add powerful spreadsheets to your Windows Forms Applications |
 |
Make life easier for your users with the SpreadsheetGear for .NET Windows Forms
Spreadsheet Control which provides rich functionality including familiar keyboard
and mouse selections, in-cell editing, a FormulaBar control, go to, find, replace, cut, copy, paste,
clear, undo, redo, pictures, cell comments, data validation, conditional formats, grouping & outlining, stable sort, text objects, form
controls, autoshapes, interruptible background calculation, printing, real-time
workbook updates, multiple workbooks, Display Reference, Workbook Designer, Workbook
Explorer, Range Explorer and much more. |
Excel to DataGrid |
|
Quickly populate DataGrids from Excel workbooks without Excel |
 |
Excel is an excellent source of data for the Windows Forms DataGrid and ASP.NET
DataGrid controls included in Microsoft .NET, as well as the many third party controls
which accept data from DataSets and DataTables. With our spreadsheet component and
one line of Microsoft Visual C# or Microsoft Visual Basic .NET code, you can quickly
read an Excel workbook and return any range or set of ranges as a DataTable or DataSet. |
Excel Calculations |
|
Fastest and most complete Excel compatible calculations without Excel |
 |
The true power of SpreadsheetGear for .NET is realized when using its superior calculation
engine. Unmatched performance and accuracy deliver a compelling advantage to data
critical client and web applications. There is no need to rely on Excel to calculate
spreadsheet data. Simply load or create a workbook, change and add values and formulas,
and calculate results with the fastest and most complete calculation engine available
in a spreadsheet component. |
Excel Charting |
|
Enable users to visualize data by adding Excel charts to reports |
 |
Richly formatted workbooks with fast and complete calculations are the heart and
soul of a spreadsheet, but the ability to make good decisions is greatly enhanced
by the ability to visualize data. Enhance your users understanding of their data
by taking advantage of SpreadsheetGear for .NET's ability to read and write Excel
charts and modify the data which these charts refer to. |