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.

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

TRIAL LICENSE KEY
———————–
If you need a trial license key, start your .NET Core trial from https://www.syncfusion.com/account/manage-trials/start-trials under your Syncfusion account. Then you can obtain your trial license key from the downloads page.

Check if you are eligible for a free license for all Syncfusion products on our Community License page https://www.syncfusion.com/products/communitylicense .

BOOKMARK DETAILS
———————
[00:00] Introduction
[01:00] Project creation
[01:27] Installed the XlsIO library
[02:09] Register license key
[02:22] Create excel document
[04:41] Added text and images in worksheet
[07:22] Create hyperlink in worksheet
[8:22] Added formulas to worksheet
[09:57] Shown the output
[10:22] Edit excel document

Excel Library
————
Product overview: https://www.syncfusion.com/document-processing/excel-framework/net-core
Documentation: https://help.syncfusion.com/file-formats/xlsio/create-excel-file-csharp-vbnet
Download free trial: https://www.syncfusion.com/account/manage-trials/start-trials
NuGet package: https://www.nuget.org/packages/Syncfusion.XlsIO.Net.Core
GitHub: https://github.com/SyncfusionExamples/XlsIO-Examples

SUBSCRIBE
————–
Syncfusion on YouTube: http://bit.ly/syncfusionyoutube
Sign up to receive email updates: http://bit.ly/syncfusionemail

SOCIAL COMMUNITY
—————————–
Facebook: https://www.facebook.com/Syncfusion/
Twitter: https://twitter.com/Syncfusion
LinkedIn: https://www.linkedin.com/company/syncfusion/
Instagram: https://www.instagram.com/syncfusionofficial/

#excel #aspdotnetcore #fileformats