Winnovative.ExcelLib.NetCore
11.0.0
Prefix Reserved
dotnet add package Winnovative.ExcelLib.NetCore --version 11.0.0
NuGet\Install-Package Winnovative.ExcelLib.NetCore -Version 11.0.0
<PackageReference Include="Winnovative.ExcelLib.NetCore" Version="11.0.0" />
paket add Winnovative.ExcelLib.NetCore --version 11.0.0
#r "nuget: Winnovative.ExcelLib.NetCore, 11.0.0"
// Install Winnovative.ExcelLib.NetCore as a Cake Addin #addin nuget:?package=Winnovative.ExcelLib.NetCore&version=11.0.0 // Install Winnovative.ExcelLib.NetCore as a Cake Tool #tool nuget:?package=Winnovative.ExcelLib.NetCore&version=11.0.0
Winnovative Excel Library for .NET Core
Excel Library for .NET Core | Excel to PDF for .NET Core | Free Trial | Licensing | Support
Winnovative Excel Library for .NET Core can be easily integrated in your applications targeting .NET Core or .NET Standard to create new Excel documents or to edit existing Excel documents.
This version of the library is compatible with .NET Core and .NET Standard on Windows platforms.
For applications targeting .NET Framework on Windows you can use the library from Winnovative.ExcelLib NuGet package.
Main Features
- Does not depend on Microsoft Office Excel
- Create new Excel documents or edit existing Excel documents
- Support for Excel 97-2003 (.xls), Excel 2007 and 2010 (.xlsx) formats
- Load a workbook from a stream or from a file
- Save a workbook to a stream or to a file
- Load data from CSV files and save data to CSV format
- Load data from a .NET DataTable or save data to a DataTable object
- Add chart shapes or chart worksheets to a workbook
- Add formulas and array formulas to a worksheet
- Add global styles to a workbook
- Advanced support for Excel 2007 and 2010 gradients and textures
- Add named ranges at worksheet or workbook level
- Add images to a worksheet
- Add hyperlinks and comments to a worksheet
- Support for data validation
- Support for workbook windows and structure protection
- Support for worksheet data protection
- ead and write password protection for .xls workbooks
- Support for worksheet page setup - headers, footers, size, margins, orientation
- Support for workbook properties - author, subject, comments
Compatibility
Winnovative Excel Library for .NET Core is compatible with Windows platforms which support .NET Standard 2.0 or above, including the platforms listed below:
- .NET Core 8, 7, 6, 5, .NET Standard 2.0 , .NET Framework 4.6.2 (and above)
- Windows 32-bit (x86) and 64-bit (x64)
- Azure Cloud Services and Azure Virtual Machines
- Web, Console and Desktop applications
Getting Started
After the reference to library was added to your project you are now ready to start writing code to create and edit Excel documents in your .NET application. You can copy the C# code lines from the section below to create an Excel document and save it to a memory buffer for further processing, to an Excel file or send it to browser for download in ASP.NET applications.
C# Code Samples
At the top of your C# source file add the using Winnovative.ExcelLib;
statement to make available the Winnovative Excel Library API for your .NET application.
// add this using statement at the top of your C# file
using Winnovative.ExcelLib;
To create an Excel workbook and save it in an Excel file you can use the C# code below.
// Create an Excel 2007 (.xlsx) workbook
ExcelWorkbookFormat workbookFormat = ExcelWorkbookFormat.Xlsx_2007;
// use the code below instead to create an Excel 97-2003 (.xls) workbook
//ExcelWorkbookFormat workbookFormat = ExcelWorkbookFormat.Xls_2003;
// create the workbook in the desired format with a single worksheet
ExcelWorkbook workbook = new ExcelWorkbook(workbookFormat);
// get the first worksheet in the workbook
ExcelWorksheet worksheet = workbook.Worksheets[0];
// add a style to workbook
ExcelCellStyle helloWorldStyle = workbook.Styles.AddStyle("HelloWorldStyle");
helloWorldStyle.Alignment.HorizontalAlignment = ExcelCellHorizontalAlignmentType.Left;
helloWorldStyle.Alignment.VerticalAlignment = ExcelCellVerticalAlignmentType.Center;
helloWorldStyle.Font.Size = 14;
helloWorldStyle.Font.Bold = true;
// add a text to worksheet using the created style
worksheet["A1"].Text = "Hello World from Winnovative !!!";
worksheet["A1"].Style = helloWorldStyle;
worksheet["A1"].Style.Font.Color = Color.Blue;
worksheet["A1"].RowHeightInPoints = 19.5;
// autofit the Hello World text column
worksheet.AutofitColumn(1);
if (workbookFormat == ExcelWorkbookFormat.Xlsx_2007)
{
// the workbook is saved in Excel 2007 (.xlsx) format
workbook.Save("GettingStarted.xlsx");
}
else if (workbookFormat == ExcelWorkbookFormat.Xls_2003)
{
// the workbook is saved in Excel 97-2003 (.xls) format
workbook.Save("GettingStarted.xls");
}
// close the workbook
workbook.Close();
To create an Excel workbook and save it in a memory buffer and then save it to a file you can use the C# code below.
// Create an Excel 2007 (.xlsx) workbook
ExcelWorkbookFormat workbookFormat = ExcelWorkbookFormat.Xlsx_2007;
// use the code below instead to create an Excel 97-2003 (.xls) workbook
//ExcelWorkbookFormat workbookFormat = ExcelWorkbookFormat.Xls_2003;
// create the workbook in the desired format with a single worksheet
ExcelWorkbook workbook = new ExcelWorkbook(workbookFormat);
// get the first worksheet in the workbook
ExcelWorksheet worksheet = workbook.Worksheets[0];
// add a style to workbook
ExcelCellStyle helloWorldStyle = workbook.Styles.AddStyle("HelloWorldStyle");
helloWorldStyle.Alignment.HorizontalAlignment = ExcelCellHorizontalAlignmentType.Left;
helloWorldStyle.Alignment.VerticalAlignment = ExcelCellVerticalAlignmentType.Center;
helloWorldStyle.Font.Size = 14;
helloWorldStyle.Font.Bold = true;
// add a text to worksheet using the created style
worksheet["A1"].Text = "Hello World from Winnovative !!!";
worksheet["A1"].Style = helloWorldStyle;
worksheet["A1"].Style.Font.Color = Color.Blue;
worksheet["A1"].RowHeightInPoints = 19.5;
// autofit the Hello World text column
worksheet.AutofitColumn(1);
// save the workbook in a memory buffer
byte[] excelDocumentBuffer = workbook.Save();
// close the workbook
workbook.Close();
if (workbookFormat == ExcelWorkbookFormat.Xlsx_2007)
{
// save the memory buffer in an Excel 2007 (.xlsx) format file
System.IO.File.WriteAllBytes("GettingStarted.xlsx", excelDocumentBuffer);
}
else if (workbookFormat == ExcelWorkbookFormat.Xls_2003)
{
// save the memory buffer in Excel 97-2003 (.xls) format file
System.IO.File.WriteAllBytes("GettingStarted.xls", excelDocumentBuffer);
}
To create in your ASP.NET Core applications an Excel document in a memory buffer and then send it for download to browser you can use the C# code below.
// Create an Excel 2007 (.xlsx) workbook
ExcelWorkbookFormat workbookFormat = ExcelWorkbookFormat.Xlsx_2007;
// use the code below instead to create an Excel 97-2003 (.xls) workbook
//ExcelWorkbookFormat workbookFormat = ExcelWorkbookFormat.Xls_2003;
// create the workbook in the desired format with a single worksheet
ExcelWorkbook workbook = new ExcelWorkbook(workbookFormat);
// get the first worksheet in the workbook
ExcelWorksheet worksheet = workbook.Worksheets[0];
// add a style to workbook
ExcelCellStyle helloWorldStyle = workbook.Styles.AddStyle("HelloWorldStyle");
helloWorldStyle.Alignment.HorizontalAlignment = ExcelCellHorizontalAlignmentType.Left;
helloWorldStyle.Alignment.VerticalAlignment = ExcelCellVerticalAlignmentType.Center;
helloWorldStyle.Font.Size = 14;
helloWorldStyle.Font.Bold = true;
// add a text to worksheet using the created style
worksheet["A1"].Text = "Hello World from Winnovative !!!";
worksheet["A1"].Style = helloWorldStyle;
worksheet["A1"].Style.Font.Color = Color.Blue;
worksheet["A1"].RowHeightInPoints = 19.5;
// autofit the Hello World text column
worksheet.AutofitColumn(1);
// save the workbook in a memory buffer
byte[] excelDocumentBuffer = workbook.Save();
// close the workbook
workbook.Close();
FileResult fileResult = null;
if (workbookFormat == ExcelWorkbookFormat.Xlsx_2007)
{
fileResult = new FileContentResult(excelDocumentBuffer,
"Application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
fileResult.FileDownloadName = "GettingStarted.xlsx";
}
else if (workbookFormat == ExcelWorkbookFormat.Xls_2003)
{
fileResult = new FileContentResult(excelDocumentBuffer,
"Application/x-msexcel");
fileResult.FileDownloadName = "GettingStarted.xls";
}
return fileResult;
Free Trial
You can download the full Winnovative Excel Library for .NET Core package from Winnovative Software Downloads page of the website.
The package for .NET Core contains the product binaries, a demo Visual Studio project with full C# code for ASP.NET Core targeting .NET Core 6.0 and later versions, the library documentation in CHM format.
You can evaluate the library for free as long as it is needed to ensure that the solution fits your application needs.
Licensing
The Winnovative Software licenses are perpetual which means they never expire for a version of the product and include free maintenance for the first year. You can find more details about licensing on website.
Support
For technical and sales questions or for general inquiries about our software and company you can contact us using the email addresses from the contact page of the website.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
- System.Drawing.Common (>= 5.0.3)
- System.Text.Encoding.CodePages (>= 5.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
11.0.0 | 122 | 10/14/2024 |