SpreadsheetGear - performance spreadsheet components
| | | |
Products
Downloads
Support
Company
Excel Reporting Samples
Easily create richly formatted Excel reports without Excel
Excel Reporting With the wide adoption of Microsoft Excel, there is no substitute for taking advantage of spreadsheet components in your Microsoft .NET Framework projects. You can use SpreadsheetGear for .NET to deliver Microsoft Excel reports in a variety of ways. The following samples show some basic ways to create Excel content in ASP.NET projects, and are easily adaptable to a wide range of Microsoft .NET solutions.
  
Excel Report in Excel
This sample shows how to create a new workbook, add some values, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Excel Report in Browser
This sample shows how to create a new workbook, add some values, and stream it to Microsoft Excel in a browser.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Excel Report with Formulas and Formatting
This sample shows how to create a new workbook, add values, formulas, defined names and formatting, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Excel Report with Picture
This sample shows how to create a new workbook, add a picture, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source]
  
DataTable to Excel Workbook
This sample shows how to create a new workbook, copy data from a DataTable, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source] | [View XML]
  
DataSet to Excel Workbook with Formats and Formulas
This sample shows how to create a new workbook, insert data from multiple DataTables, merge this data with formatting and formulas from a template workbook, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source] | [View Template]
  
Excel Workbook Consolidation
This sample shows how to utilize the IRange.Copy method to dynamically copy and consolidate data from multiple workbooks.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Group, Outline and Summarize to Excel
This sample shows how to utilize various outline APIs to create a report with the ability to expand and collapse detail levels of data.
[Run Sample] | [C# Source] | [VB.NET Source]
SpreadsheetGear for .NET
2007 V3.1 Now Available
See What's New and
download the Licensed or
Evaluation version Now.
Spreadsheet Component
Industry Veterans
"For more than twenty years, we have been creating and leading the development of high performance spreadsheet technology which is used by most of the Fortune 500."

Joe Erickson
Founder and CEO
SpreadsheetGear LLC
Creating Excel Reports
Has Never Been Easier
"I really am happy with SpreadsheetGear for .NET. It works fantastic, very smooth to handle. Creating Excel Reports has never been easier for me!"

Wolfgang Kamir
Softwaretailor
Baden, Lower Austria
ASP.NET and
SpreadsheetGear
A Match Made in Heaven
"ASP.NET and Microsoft Excel is a dangerous combination. ASP.NET and SpreadsheetGear is a match made in heaven. When you need your web or Windows app to interact with Excel files with lightening speed and no COM crashes, SpreadsheetGear for .NET is what you use. This product truly separates the men from the boys in the spreadsheet control marketplace."

Robbe Morris
Microsoft MVP - C#
Co-founder of EggHeadCafe.com and former Gartner Sr. Software Engineer
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
Vision and Ability for Advanced Spreadsheets
September 20, 2005 - "With SpreadsheetGear, we finally have a company that understands our requirements in regards to supporting the Microsoft Excel file format in the Microsoft .NET Framework. SpreadsheetGear has the vision and the ability to provide the advanced spreadsheet functionality our customers expect in our products."

Tim Tow
President
Applied OLAP, Inc.
Former Microsoft Excel MVP
The Daily Grind Reviews SpreadsheetGear for .NET
September 22, 2005 - "The license allows royalty free deployment, making this a cost effective alternative to Excel as well as a technically superior one for generating worksheets and performing heavy-duty calculations from your .NET applications."

Mike Gunderloy
Lead developer for Larkware
Author of numerous books and articles on programming.
Over 100 Times Faster
Than Other Controls
"We just wanted you to know how thrilled we are by the performance we are seeing with SpreadsheetGear for .NET. A 6,000 KB Excel workbook is loading into the WorkbookView control in less than a second. This is over 100 times faster than other controls we’ve tested. That difference makes it possible for us to develop and release a viable product with the Microsoft .NET Framework."

Amy Tate
Chief .NET Architect
Applied OLAP, Inc.
Huntsville, Alabama
Copyright © 2003-2008 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.
Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.