Export the core asp net core to Excel

Question

I am not sure that this question can be published here, but I think that this may interest many programmers. I need a package that will provide me with an interface for creating Excel files. I looked at nuget and found several packages, but not one that supports the asp net kernel.

Answer 1

Find the Open XML SDK .

I use v2.5 with ASP.NET Core + .NET4.6, but as far as I know, the latest version of v2.7 adds support for .NET Standard 1.3 - check out the change log .

Additional Information:

• Where to get the NuGet package
• Documentation
• Open XML SDK 2.5 for Office
• NuGet Open XML SDK

Answer 2

; , .

ClosedXML

• AlphaNumeric Cell Navigation, . ws.Cell("B2").Value = "Contacts";
• How to's
• Excel Microsoft.
• PM > Install-Package ClosedXML

NPOI

• , .

  var rowIndex = 0; IRow row = sheet1.CreateRow(rowIndex); row.Height = 30 * 80; row.CreateCell(0).SetCellValue("this is content");

• / xls, doc, ppt.
• nuget: Install-Package DotNetCore.NPOI

EPPlus.Core

• EPPlus Library .NET Core.

:

Datatables.net

, Excel.

, excel, , . , .

• DOM
• Excel

Answer 3

GrapeCity Document API Excel .NET core 2. 0+ (-), : https://www.grapecity.com/documents-api-excel

API - VSTO, :

Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.Worksheets[0];