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