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