ExcelToPdf 6.0.1

ExcelToPdf

中文版 | English

This is a simple project to export Excel to PDF.

It consists of two steps:

1. Use NpoiExcelHelper. ExcelToHtml method will excel export to HTML
2. 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

• WkHtmlToPdf-DotNet
• NPOI

This project also provides a simple encapsulation of customizations, see the customization section of the documentation.

Install

Install-Package ExcelToPdf -Version 6.0.0

Sample

For details, please refer to ExcelToPdfSample project.

Dependency Injection

// in StartUp.cs
services.AddExcelToPdf("temp");

Export

private readonly ILogger<IndexModel> _logger;
private readonly ExcelToPdfService _excelToPdfService;

// inject ExcelToPdfService from controller
public IndexModel(ILogger<IndexModel> logger, ExcelToPdfService excelToPdfService)
{
	_logger = logger;
	_excelToPdfService = excelToPdfService;
}

// export to pdf
public void OnPostSimpleExport()
{
	FileInfo excelFileInfo, htmlFileInfo, pdfFileInfo;
	SetupSample(out excelFileInfo, out htmlFileInfo, out pdfFileInfo);

	// export pdf
	_excelToPdfService.ExportToPdf(excelFileInfo.FullName, pdfFileInfo.FullName);

	this.Message = $"Export Success, Pdf file save to: {pdfFileInfo.FullName}";
}

Note that using asp.net requires the injection of IConverter first, as follows:

in StartUp.cs

// injection
services.AddHtmlToPdf();

Custom

Custom excel export to html

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, can use configGlobalSettings parameter to custom pdf:

// ... other code ...
// export pdf
_excelToPdfService.ExportToPdf(excelFileInfo.FullName, pdfFileInfo.FullName, configPdfGlobalSettings: config =>
{
	config.Orientation = Orientation.Landscape;
	config.ColorMode = ColorMode.Grayscale;
	config.Margins.Left = 150;
	config.Margins.Top = 50;
});
// ... other code ...

GlobalSettings Commonly used attributes：

Docker and linux

How-to-use-NPOI-on-Linux