Syncfusion.XlsIO.NET

Syncfusion Essential XlsIO is a high-performance and feature-rich .NET Excel library to work with Microsoft Excel documents. This Excel library allows you to create, read, and edit Microsoft Excel files in any .NET application. It offers APIs to support Microsoft Excel equivalent features along with conversion APIs to easily convert Excel files to PDF, images, and more.

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.

Getting Started

Installation commands

• Simply run Install-Package Syncfusion.XlsIO.Net.Core from the Package Manager Console in Visual Studio to fetch the NuGet package.
• If you already have Syncfusion.XlsIO.Net.Core for .NET and want to upgrade the version, please run Update-Package Syncfusion.XlsIO.Net.Core to get the latest version.
• You can run the following snippets in your environment to see how Syncfusion.XlsIO.Net.Core works.

Create an Excel document using XlsIO

The following code snippet explains how to create an Excel document.

//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();
}

Read an Excel document using XlsIO

The following code snippet explains how to read an Excel document.

//Initialize ExcelEngine.
using (ExcelEngine excelEngine = new ExcelEngine())
{
    //Initialize IApplication.
    IApplication application = excelEngine.Excel;
	//Set the default version as Xlsx.
    application.DefaultVersion = ExcelVersion.Xlsx;
    //Load an existing workbook into IWorkbook.
    FileStream fileStream = new FileStream("Sample.xlsx", FileMode.Open, FileAccess.Read);
    IWorkbook workbook = application.Workbooks.Open(fileStream);
    //Save the Excel document.
	FileStream stream = new FileStream("Output.xlsx", FileMode.Create, FileAccess.ReadWrite);
    workbook.SaveAs(stream);
    stream.Dispose();
}

File Formats supported by XlsIO

Syncfusion Essential XlsIO supports .xls, .xlsx, .xlsm, .xltm, .xltx, .xml, .csv, .txt and .ods file formats.

Compatible Microsoft Excel Versions

• Microsoft Excel 97-2003
• Microsoft Excel 2007
• Microsoft Excel 2010
• Microsoft Excel 2013
• Microsoft Excel 2016
• Microsoft Excel 2019

Resources

• Product page: Syncfusion Excel Framework
• Documentation: Syncfusion Excel library
• Online demo: Syncfusion Excel library - Online demos
• Blogs: Syncfusion Excel library - Blogs
• Knowledge Base: Syncfusion Excel library - Knowledge Base
• Ebooks: Syncfusion Excel library - Ebooks
• FAQ: Syncfusion Excel library - FAQ

Support and feedback

• For any other queries, reach our Syncfusion support team or post the queries through the community forums.
• Request new feature through Syncfusion feedback portal.

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 licnense 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 26,000+ customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.

Today, we provide 1600+ 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.

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. To acquire a license, you can purchase one here or start a free 30-day trial here.

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