This sample shows how to load a workbook containing a chart, insert data from a DataTable which automatically expands the chart link range, and stream it to Microsoft Excel.
SpreadsheetGear 2017 adds a new SpreadsheetGear for .NET Standard product, official support for Excel 2019 and Excel for Office 365, 51 new Excel functions, full conditional formatting support, enhanced workbook protection and encryption, cell gradient rendering and more.
Microsoft Chooses SpreadsheetGear for .NET
"After carefully evaluating SpreadsheetGear, Excel Services, and other 3rd party options, we ultimately chose SpreadsheetGear for .NET because it is the best fit for MSN Money."
Chris Donohue Program Manager MSN Money
Spreadsheet Component Industry Veterans
"Our key developers have over fifty years of combined experience developing high performance commercially available spreadsheet technology which is used by most of the Fortune 500."
"We integrated SpreadsheetGear for .NET with an existing application with about two days work and it reduced the time it takes to generate a critical daily report from 20 minutes to 4 seconds. Thanks for making my team look like miracle workers!"
Luke Melia, Software Development Manager Oxygen Media, New York
Brilliant Product Fanatical Support
“Thank you again for your brilliant product and fanatical support. We have never looked back since we discarded FarPoint’s Spread in favour of SpreadsheetGear."
Earl J. Steyn Data Prime Solutions Johannesburg, South Africa
Performance, Flexibility Priceless Support
"We started to use SpreadsheetGear for .NET almost two years ago when the performance of other controls was becoming problematic. We needed a control that could handle large workbooks with complex formulas to be able to apply Monte Carlo simulation to financial statements. Since that time SpreadsheetGear for .NET has become our tool of choice not only for the performance but also for the flexibility. But most of all, the technical support we receive from SpreadsheetGear LLC is priceless; it has always been fast and accurate with the vision to arrive at the desired solution."
Frédérick Faucher Analyste Financier Solutions Modex Inc. Montréal, Canada
I conducted a three month analysis comparing three top spreadsheet controls for .NET application developers: SpreadsheetGear, SyncFusion XlsIO, and ComponentOne Spread.NET. The definite winner was SpreadsheetGear, with ComponentOne Spread.NET in second. SpreadsheetGear provides the most Excel-like experience, is the most performant, and provides the most responsive and capable product support.
I build a reporting engine for my company and SpreadsheetGear made it awesome. Our customers have been very pleased. I wanted to share my extensive analysis with any other developers out there trying to find the right spreadsheet control for their .NET application.
Joseph Fluckiger Sr. Software Architect Thermo Fisher Scientific Austin, TX
SpreadsheetGear Samples and Tutorials
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.
Tutorials demonstrate SpreadsheetGear for .NET Standard in ASP.NET Core MVC, .NET Core, Xamarin.iOS and Xamarin.Android. SpreadsheetGear for .NET Standard could also be used on other platforms such as the full .NET Framework, Universal Windows Platform (UWP), Xamarin.Forms, Mono and any other platform that supports .NET Standard 1.3.
Make life easier for your users with the SpreadsheetGear Windows Forms and WPF spreadsheet controls which combine Visual Studio integration with the ability to create, read, modify, view, edit, format, calculate, sort, filter, print and write Microsoft Excel 97-2019 and Excel for Office 365 workbooks without Excel.
Take your browser based applications beyond the limits of HTML and JavaScript with SpreadsheetGear for Silverlight which is built on the same Excel compatible spreadsheet and charting engines as SpreadsheetGear for .NET.
Have an up-to-date and valid License Number? Download the latest Licensed versions of SpreadsheetGear Now! If you need a License, go to our Purchase Page to purchase one today.
The 30-Day Evaluation versions of SpreadsheetGear are good representations of the fully licensed products. Beyond the presence of multiple timeout mechanisms, the only other limitation placed in these builds is the addition of watermarks over images rendered with the Image API.