Migration from Office Automation to Syncfusion® XlsIO
24 Jul 20261 minute to read
Why Syncfusion®’s XlsIO over Office Automation?
- Office automation can be extremely slow when deployed on a server, and it is highly unstable when multiple Excel objects are instantiated concurrently on the server. XlsIO is designed to work under these conditions as a 100% native .NET component, so it can easily handle concurrent requests from multiple users.
- XlsIO has a very intuitive and easy-to-use object model. You can create richly formatted spreadsheets in just a few minutes.
- Essential® XlsIO has a royalty-free licensing model, so you do not need a Microsoft Excel license on the server, unlike Office Automation.
Migrating from Microsoft Interop to Syncfusion® XlsIO is straightforward. The following section lists common Excel features. Each topic links to a dedicated migration guide and includes:
- A description of the feature.
- Interop and XlsIO code (in both C# and VB.NET) for comparison and easy migration.
Topic links
- Add Worksheets to Workbook
- Activate a Worksheet
- Protect Excel Workbook
- Unprotect Excel Workbook
- Create Pie Chart in Excel
- Use Formulas in Excel
- Create Named Range in Excel
- Add Comments in Excel
- Delete Comments in Excel
- Merge Cells in Excel
- Unmerge Cells in Excel
- Apply Borders in Excel
- Add Hyperlinks in Excel
- Hide Excel Worksheets
- Unhide Excel Worksheets
- Rotate Text in Cells
- Filter Excel Data
- Wrap Text in Excel
- Set Background for Excel Worksheet