Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{section}{column:width=48%}

h1. New in ExcelWriter 8.6\!

* [PivotTableSettings.ClassicLayout] for ExcelApplication
* Better performance for opening XLSX/XLSM files with many formulas
* Sparkline support for ExcelTemplate
* For more, see our [OW8:Change Log]

h1. Getting Started


[Help Installing ExcelWriter|OW8:Installation]
[Hello, World\! Tutorial|Hello World Tutorial]

h1. What is ExcelWriter?

*ExcelWriter is a .NET library and API*. It allows you to generate, manipulate, and read Excel documents from your own applications. You can use ExcelWriter to process workbooks with a fully programmatic object model, or design report templates in Office and quickly merge them with data. ExcelWriter can generate spreadsheets in Microsoft Excel format (.xls) or Office Open XML format (.xlsx) and it will preserve all of the familiar features associated with Excel workbooks.
{column}{column:width=52%}

{panel:title=ExcelWriter Documentation Sections|borderColor=#BBB|bgColor=white|titleBGColor=#EEE|titleColor=#444}{children:depth=2|style=h4}
{panel}
{column}{section}


h1. Standard Edition vs. Enterprise Edition

_ExcelWriter comes in two editions, depending on the functionality needed for your application._

{section}{column:width=50%}

{panel:title=ExcelWriter Standard Edition|borderColor=#bbb|bgColor=white|titleBGColor=#EEE|titleColor=#444}
ExcelWriter SE provides a template-driven development approach, meaning that templates are developed in Excel and then processed with just a few lines of code to import data. With [Reporting Services integration|RS8:SSRS Integration], reports can be created inside Excel and processed by Reporting Services with no code written at all.
{panel}
{column}{column:width=50%}

{panel:title=ExcelWriter Enterprise Edition|borderColor=#bbb|bgColor=white|titleBGColor=#EEE|titleColor=#444}
ExcelWriter EE builds on ExcelWriter SE, adding additional features for enterprise-class Web applications requiring maximum Excel functionality and high volume of report generation, such as programmatic control of Excel elements and integration with the SharePoint platform.
{panel}
{column}{section}


h2. Feature Comparison

|| Feature|| Standard Edition || {}Enterprise Edition ||
| Template-Driven Development | (/)  | (/) |
| Full Programmatic Control | \-  | (/) |
| Nesting and Grouping | \- | (/) |
| SharePoint Integration | \- | (/) |
| Reporting Services Integration | (/) | (/) |
| Reporting Services Formulas | \- | (/) |
Section

What is ExcelWriter?

ExcelWriter is a .NET library and API. It allows you to generate, manipulate, and read Excel documents from your own applications. You can use ExcelWriter to process workbooks with a fully programmatic object model, or design report templates in Office and quickly merge them with data. ExcelWriter can generate spreadsheets in Microsoft Excel format (.xls) or Office Open XML format (.xlsx) and it will preserve all of the familiar features associated with Excel workbooks.

 

Panel
borderStylenone
borderColor#A8A8A8

ExcelWriter Documentation Sections

Section
Column
width60
Panel
borderStylenone
titleLearning Center

 New to ExcelWriter? Need a how-to or some sample code?

Panel
bgColor#6691BC

ExcelWriter Learning Center


Panel
borderStylenone
titleAPI Reference
Panel
bgColor#6691BC

ExcelTemplate API 


Panel
bgColor#6691BC

ExcelApplication API


Panel
bgColor#6691BC

SharePointIntegration API


Panel
borderStylenone
titleInstallation
Panel
bgColor#6691BC

Installation


Column
width40