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.
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.