|
Easily create richly formatted Excel reports without Excel |
|
|
 |
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 2009 to deliver Microsoft Excel 97-2007 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]
|
|
|
|
| NEW! 93 Analysis Toolpak functions, enhanced printing support, CSV and text files, auto fill, goal seeking, data series, bubble charts, chart axis titles, gradients, rotated text and more. Download the Licensed version or the FREE Evaluation Now. |
|
"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 |
|
"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 |
|
"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 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 |
|
"Fantastic evaluation -- I started with a customer’s Excel workbook with a dashboard containing variable cells and a chart. Using SpreadsheetGear, and your Dashboard from 1693 Analytics sample as a template, I created my own ASP.NET page to display our client’s dashboard, and update based on the selection of parameters which get plugged into the variable cells. And I got this working in a single afternoon."
Andy Hofer
Directory of Development
NST Systems, Inc.
Stamford, CT |
|
“Your interface-based approach is refreshing: the API is natural and the underlying code is blindingly fast for what it does.
Changing my Excel abstraction to use SpreadsheetGear brought a 2 month pull from 48 minutes (2880 seconds) to 12.7 seconds.
Wow!"
Dennis C. Wright
dWare.biz, LLC |
|
"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 |
|
"I must say that in terms of structure and completeness, SpreadsheetGear kills the competition."
Mark Keogh, Technical Lead
BCC AdSystems
Sydney, Australia |
|
"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 |
|
"SpreadsheetGear for .NET is a fantastically powerful spreadsheet component which is very easy to use and expand. We delivered our mandatory customer requirements well before time so we had plenty of time to implement the nice-to-have requirements nobody ever manages to deliver."
Simon Black
Software Architect
Nokia |
|
