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

{div2:class=button-style}
[Help Installing ExcelWriter|OW8:Installation]
{div2}
{div2:class=button-style}
[Hello, World\! Tutorial|Hello World Tutorial]
{div2}

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}

{align:center}

h2. Feature Comparison

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