DEV Community

Cover image for How to Create an Excel Document in ASP.NET Core using the XlsIO Library
Arun for Syncfusion, Inc.

Posted on

How to Create an Excel Document in ASP.NET Core using the XlsIO Library

See how to create a Excel document in ASP.NET Core using the Syncfusion .NET Excel Library. In this video, I will demonstrate how to create an ASP.NET Core application in Visual Studio and the steps to create and edit an excel document by adding text, images, and formulas.

Essential XlsIO is a native .NET class library that can be used to create and modify Microsoft Excel files by using C#, VB.NET and managed C++ code. It is a non-UI component that provides a full-fledged object model that facilitates accessing & manipulating the spreadsheets without any dependency of Microsoft Office COM libraries & Microsoft Office.

It's supported to create Excel documents from scratch and modify existing excel documents. Its support to import and export data and excel formulas. Supports creation and manipulation of Tables, Pivot Tables and Pivot Charts. Its ability to create and manipulate Conditional Formats and Data Validations.

Create and manipulate Charts and Sparkline. Supports creation and manipulation of Tables, Pivot Tables and Pivot Charts. Fill data using Template Markers. Clone and merge Excel worksheets. Encrypt and decrypt excel document and convert excel worksheets t image. Its supports data filtering and data sorting and convert chart in a worksheet to image.

Excel support to insert image and auto shapes and add comments and form controls. Ability to convert the excel workbook to PDF and convert Excel worksheet to HTML. Support to open and create CSV files. Its access the custom document properties of excel file and built-in document properties.

Product overview: https://www.syncfusion.com/document-processing/excel-framework/net-core

Tutorial video: https://www.syncfusion.com/tutorial-videos

Download example from GitHub: https://github.com/SyncfusionExamples/XlsIO-Examples/tree/master/Getting%20Started/ASP.NET%20Core

Top comments (0)