SpreadsheetGear - performance spreadsheet components
| | | |
Products
Samples
Downloads
Support
Company
Excel Reporting Samples
Easily create richly formatted Excel reports without Excel
Click for larger image of Excel Report generated by SpreadsheetGear 2010 and displayed in Excel 2007 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 2010 to deliver Microsoft Excel 97-2010 reports in a variety of ways. The following samples show some basic ways to create Excel content in ASP.NET projects, and are easily adapted to a wide range of Microsoft .NET solutions.
  
Simple Excel Report
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]
  
Simple Excel Report (Open XML)
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 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 Formatted Chart (Open XML)
This sample shows how to create a new workbook, add some values, add a chart, format the chart, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Excel Report with Chart (From Template Workbook)
This sample shows how to load a workbook containing a chart, add some values, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source] | [View Template]
  
Excel Report with Chart Linked to Defined Name
This sample shows how to load a workbook containing a chart series linked to a defined name, change the defined name range reference, and stream it to Microsoft Excel. For charts with multiple series, use Excel to set each chart series to refer to a unique defined name.
[Run Sample] | [C# Source] | [VB.NET Source] | [View Template]
  
Worksheet with Chart to Multiple Worksheets with Charts
This sample shows how to load a workbook containing a chart, and use the worksheet copy routines to create multiple worksheets from one worksheet, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source] | [View Template]
  
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]
  
DataTable to Excel Workbook with Chart
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.
[Run Sample] | [C# Source] | [VB.NET Source] | [View Template]
  
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 2010
Now Available
NEW!  Autofilters, password protected workbooks, macro-enabled Open XML (.xlsm) support, Excel 2010 support, Visual Studio 2010 and .NET 4.0 support, a number of charting features and more.

Download the FREE Trial.
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
Reduced Time From
20 Minutes to 4 Seconds
"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
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
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.
SpreadsheetGear for .NET Worked as Described
"After trying every Microsoft Excel compatible spreadsheet solution for the .NET Framework I could find, SpreadsheetGear for .NET is the only one that actually worked as described."

Michael Garnett
Interpublic Group
New York, NY
SpreadsheetGear for .NET
So Much Easier
"I have one big problem with Spreadsheetgear for .NET, my billable hours are going to go down because your product is so much easier to use than a web grid. Yikes!

I sure wish I had found your product a couple of years ago. And converting my webgrid code over to SpreadsheetGear for .NET is going very quickly because all of the logic is already coded and I just have to write to the spreadsheet.

I really like not having to insert columns and rows when I need them. I really like your product so far."

Bruce Hemmerich
Manager - Business and Technical Solutions
KeyChainData, LLC
I'm Impressed With the
Ease of Use and Speed
"I'm impressed with the ease of use and speed of SpreadsheetGear for .NET in rendering large workbooks from a web page. Congrats for your work!"

José M. Marcenaro
Tercer Planeta
Buenos Aires, Argentina
Best Component Purchase
for Many Years
“SpreadsheetGear for .NET provides a platform for spreadsheet web extension second to none. We were able to implement our custom formulas using the SpreadsheetGear engine with ease and these interact with the Excel functions seamlessly. The performance is superb and in many cases faster than in Excel which has been a pleasant surprise. The expertise of the development team is very apparent and we look forward to the new product enhancements coming down the line. From a return on investment perspective this has been our best component purchase for many years."

Mark Scanlon
Managing Director
XLCubed Ltd
Above and Beyond Support, Exceptional
"Although there was an initial issue related to date formatting associated with a cultural problem, I found that SpreadsheetGear provided myself, and ultimately the bank, with above and beyond support, providing us with the necessary fix for the issue within 2 days.  This is nothing less than exceptional, and I for one would like to thank SpreadsheetGear for their tenacity, enthusiasm and dedication to their product."

David Lashley
IT Development Manager
Commercial Bank of Qatar
Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark 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.