Syncfusion.XlsIO.NET

Syncfusion .NET Excel Library

The Syncfusion .NET Excel (XlsIO) library is a feature-rich and high-performance .NET Excel library that is used to create, read, and edit Excel documents programmatically without Microsoft Office dependencies.

Features Overview | Docs | API Reference | Online Demo | GitHub Examples | Blogs | Support | Forums | Feedback

Key features

• Easily import and export data from/to common business objects.
• Performs quick evaluation with 400+ functions.
• Imports data into a customized format using Template Markers.
• Create and edit all chart types including Excel 2016 charts.
• Cell data validations can be applied with operators, alert messages, custom formulas, and drop-down lists.
• Highlights important cells by conditional formats.
• Performs various cell-level operations like resizing, hide or unhide, insert or delete, group and ungroup, and so on.
• Supports various formatting like number formats, text alignments, font settings, border settings, color settings, rich-text, and so on.
• Supports applying built-in styles and custom styles to cells.
• Sorts data based on cell value, cell color, and font color.
• Filters data based on cell value, cell color, icons, and so on.
• Create and edit the auto shapes, comments, text boxes, combo boxes, check boxes, and option buttons.
• Enables page settings like orientation, paper size, scaling, margins, print titles, header and footer, and so on.

System Requirements

• System Requirements

Getting Started

You can fetch the Syncfusion .NET Core Excel library NuGet by simply running the command Install-Package Syncfusion.XlsIO.NET from the Package Manager Console in Visual Studio.

Try the following code snippet to create a simple Excel document.

using Syncfusion.XlsIO;
using System.IO;

//Initialize ExcelEngine.
using (ExcelEngine excelEngine = new ExcelEngine())
{
    //Initialize IApplication.
    IApplication application = excelEngine.Excel;
    //Set the default version as Xlsx.
    application.DefaultVersion = ExcelVersion.Xlsx;
    //Create a new workbook with one worksheet.
    IWorkbook workbook = application.Workbooks.Create(1);
    //Get the worksheet into IWorksheet.
    IWorksheet worksheet = workbook.Worksheets[0];
    //Set a value to Excel cell.
    worksheet.Range["A1"].Value = "Hello World";
    //Save the Excel document.
    FileStream stream = new FileStream("Output.xlsx", FileMode.Create, FileAccess.ReadWrite);
    workbook.SaveAs(stream);
    stream.Dispose();
}

For more information to get started, refer to our Getting Started Documentation page.

License

This is a commercial product and requires a paid license for possession or use. Syncfusion�s licensed software, including this component, is subject to the terms and conditions of Syncfusion's EULA. You can purchase a license here or start a free 30-day trial here.

About Syncfusion

Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 27,000+ customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.

Today, we provide 1700+ components and frameworks for web (Blazor, ASP.NET Core, ASP.NET MVC, ASP.NET WebForms, JavaScript, Angular, React, Vue, and Flutter), mobile (Xamarin, Flutter, UWP, and JavaScript), and desktop development (WinForms, WPF, WinUI, Flutter and UWP). We provide ready-to-deploy enterprise software for dashboards, reports, data integration, and big data processing. Many customers have saved millions in licensing fees by deploying our software.

[email protected] | www.syncfusion.com | Toll Free: 1-888-9 DOTNET