Convert Excel to PDF.

Overwrite Excel with data according to the symbol.(And convert to Excel to PDF)

Excel.Report.PDF from NuGet.

PM> Install-Package Excel.Report.PDF

First you need to implement IFontResolver. This is a PDFsharp feature used internally. I think you can understand if you refer to the test project. ->Source/Test/Test

public class CustomFontResolver : IFontResolver
{
    public byte[] GetFont(string faceName)
        //Implement so that you can get as many fonts as you need.
        => faceName.EndsWith("#b") ? Resources.NotoSansJP_ExtraBold : Resources.NotoSansJP_Regular;

    public FontResolverInfo ResolveTypeface(string familyName, bool isBold, bool isItalic)
    {
        var faceName = familyName; 
        if (isBold) faceName += "#b";
        return new FontResolverInfo(faceName);
    }
}

GlobalFontSettings.FontResolver = new CustomFontResolver();

Next, you can convert by specifying Excel. The first argument is the Excel path or Stream, and the second argument is the number or name of the target sheet.

using var outStream = ExcelConverter.ConvertToPdf(workbookPath, 1);
File.WriteAllBytes(pdfPath, outStream.ToArray());

There is also a function to overwrite Excel. First, create an Excel file according to the rules.

Write the string you want to convey to the program after the $ sign.

LoopRow copies the specified row copyRowCount times and adds a row. LoopRowData uses the original format without copying the row. It only loops over the data. You can specify the symbol of the repeating element in elementName for the column to loop over.

//Sample data.
var data = new Quotation 
{
    Title = "宴会時の食材",
    Client = "エクセルコンサルティング株式会社",
    PersonInCharge = "大谷正一"
};
data.Details.Add(new()
{
    Title = "鯛",
    Detail = "新鮮",
    Price = 10000,
    Discount = 0,
});
data.Details.Add(new()
{
    Title = "鰤",
    Detail = "新鮮",
    Price = 20000,
    Discount = 0,
});
data.Details.Add(new()
{
    Title = "ハマチ",
    Detail = "ご奉仕品",
    Price = 30000,
    Discount = 2000,
});
data.Details.Add(new()
{
    Title = "蛸",
    Detail = "ご奉仕品",
    Price = 40000,
    Discount = 1000,
});

using var book = new XLWorkbook(filePath);
var symbolConverter = new ObjectExcelSymbolConverter(data);
await book.Worksheet(1).OverWrite(new ObjectExcelSymbolConverter(data));

// Convert Excel to PDF
var newStream = new MemoryStream();
book.SaveAs(newStream);
using var outStream = ExcelConverter.ConvertToPdf(newStream, 1);
File.WriteAllBytes(pdfPath, outStream.ToArray());

It can be specified in column A.Copies the specified row as many times as blockRowCount and adds the row.
By specifying pageType and rowsPerPage, you can configure the page layout and the number of rows displayed per page for each of the three page types: First (first page), Body (middle pages), and Last (final page).

• First: The page that appears once at the very beginning of the report or list.
• Body: The middle pages used to output the main data across multiple pages.
• Last: The page that appears once at the very end to close the report or list.

MultiPageSheetSample convert to PDF Please refer to "2. [#LoopRow($elements, elementName, copyRowCount)]" for sample data.

It can display number of pages. It can be specified in any column except column A. It is only available for PDF output.

By default, only cells that contain values are rendered into the PDF.
If you put #Empty in a cell, the text itself will not be drawn, but the cell’s area will still be included in the rendering range.

Use this when you want the cell’s presence to affect the layout, but you don’t want any visible text.

This can only be specified in the A1 cell.
If you write #FitColumn in A1, the content will be automatically scaled so that it fits the PDF drawing area based on the Excel column width, excluding the left and right margins.

Use this when you want the PDF display size to be adjusted according to the column width in Excel.