Access Keys:
Skip to content (Access Key - 0)


ExcelWriter Overview

New in ExcelWriter 8.5!

  • Data markers in tab names
  • Excel 2007, 2010, and 2013 formulas
  • Delayed formula parsing - only parse when needed
  • Big fixes to CopySheet
  • For more, see our Change Log

Getting Started

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.

Standard Edition vs. Enterprise Edition

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

ExcelWriter Standard Edition

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, reports can be created inside Excel and processed by Reporting Services with no code written at all.

ExcelWriter Enterprise Edition

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.

Feature Comparison

Feature
Standard Edition
Enterprise Edition
Template-Driven Development
Full Programmatic Control
-
Nesting and Grouping
-
Word Formulas
-
SharePoint Integration
-
Reporting Services Integration
Reporting Services Formulas
-
Adaptavist Theme Builder Powered by Atlassian Confluence