Excel Automation Samples for ASP.NET
SpreadsheetGear 2012 and ASP.NET make it easy to automate Excel report generation, create dynamic dashboards from Excel charts and ranges, utilize high performance
Excel compatible calculations without Excel, and move data between Excel workbooks and DataSets, DataTables, and DataGrids.
Easily create richly formatted Excel reports without Excel
With the wide adoption of Microsoft Excel and the Office Open XML standard, there is no substitute for taking advantage of the leading spreadsheet component
in your Microsoft .NET Framework projects. You can use SpreadsheetGear 2012 to deliver Microsoft Excel 97-2010 reports in a variety of ways.
Dynamically generate great looking dashboards designed in Excel
There is a good chance that you and your users already know how to create great looking dashboards and charts in Excel. The web has a wide variety of resources
for creating "Excel Dashboards". Now you can leverage this knowledge and information by designing your dashboards and charts in Excel and deploying them with SpreadsheetGear 2012.
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 2012's comprehensive Excel compatible
Fastest and most complete Excel compatible calculations without Excel
The true power of SpreadsheetGear 2012 is realized when using its superior Microsoft Excel compatible calculation engine.
Unmatched performance and accuracy, 398 Excel compatible functions, multithreaded recalc, array formula support and more
provide a competitive advantage to any ASP.NET, Windows Forms, WPF or Silverlight application.
Quickly move data from DataGrids to Excel and back without Excel
DataGrids, DataSets and DataTables are a staple of many Microsoft .NET Framework applications. SpreadsheetGear 2012 makes it easy to copy data from workbooks
and ranges of cells to DataGrids, DataSets and DataTables. Copying the DataGrids, DataSets and DataTables back to a workbook or range of cells is just as easy.