Excel Automation Samples for ASP.NET
SpreadsheetGear 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.
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 ASP.NET projects for the Microsoft .NET Framework and .NET Core. You can use SpreadsheetGear to deliver Microsoft Excel 97-2019 and Excel for Office 365 reports in a variety of ways.

Create Dashboards from Excel Charts and Ranges
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.
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's comprehensive Excel compatible
charting support.
The true power of SpreadsheetGear 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.
DataGrids, DataSets and DataTables are a staple of many Microsoft .NET Framework applications. SpreadsheetGear 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.