ExcelToPdf 6.0.0
See the version list below for details.
dotnet add package ExcelToPdf --version 6.0.0
NuGet\Install-Package ExcelToPdf -Version 6.0.0
<PackageReference Include="ExcelToPdf" Version="6.0.0" />
paket add ExcelToPdf --version 6.0.0
#r "nuget: ExcelToPdf, 6.0.0"
// Install ExcelToPdf as a Cake Addin
#addin nuget:?package=ExcelToPdf&version=6.0.0
// Install ExcelToPdf as a Cake Tool
#tool nuget:?package=ExcelToPdf&version=6.0.0
ExcelToPdf
This is a simple project to export Excel to PDF.
It consists of two steps:
- Use
NpoiExcelHelper. ExcelToHtml
method will excel export to HTML - Use
Pdfhelper.HtmlToPdf
to convert HTML to PDF
Npoi and WkHtmlToPdf did almost all the work, and because of that, please go to these two projects to view the relevant documents, thank them very much
This project also provides a simple encapsulation of customizations, see the customization section of the documentation.
Sample
For details, please refer to ExcelToPdfSample
project.
public void OnPostSample2()
{
var excelFileInfo = new FileInfo("TestData/sample.xls");
var htmlFileInfo = new FileInfo("Output/sample.html");
var pdfFileInfo = new FileInfo("Output/sample.pdf");
if (htmlFileInfo.Directory != null && !htmlFileInfo.Directory.Exists)
{
htmlFileInfo.Directory.Create();
}
// export excel to html
NpoiExcelHelper.ExcelToHtml(excelFileInfo.FullName, htmlFileInfo.FullName, configOptions: option =>
{
option.OutputColumnHeaders = true;
});
// convert html to pdf
_converter.HtmlToPdf(htmlFileInfo.FullName, pdfFileInfo.FullName,
config =>
{
config.Orientation = Orientation.Landscape;
});
}
Note that using asp.net requires the injection of
IConverter
first, as follows:
in StartUp.cs
// injection
services.AddHtmlToPdf();
Custom
Custom excel export
With the NpoiExcelHelper.ExcelToHtml
method, can use the configOptions parameters to HTML do custom processing for export, specific definition refer to:Npoi ExcelToHtmlConverter
Custom pdf convert
With the PdfHelper.htmltopdf
method, you can use the configGlobalSettings parameter to define the PDF export. For details, see:
WkHtmlToPdf-DotNet
Docker and linux
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. 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. |
-
net6.0
- DotNetCore.NPOI (>= 1.2.3)
- Haukcode.WkHtmlToPdfDotNet (>= 1.5.66)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 6.0.0)
- PdfSharpCore (>= 1.3.11)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.