Converting from XLSX to PDF the PDF is empty

[Tigerhawk007]

I have a C# app that generates an Excel file, but I also need it is PDF format. When using MiniPdf.ConvertToPdf it creates the PDF but it is only one page and is blank. I also tried converting the same Excel file using the web page demo and it did the same thing.

Regards,
Aaron

[shps951023]

@Tigerhawk007 could you provide excel file?

[Tigerhawk007]

APOpenAging.xlsx

[shps951023]

@Tigerhawk007 I tried to convert online and it looks like no issue https://mini-software.github.io/MiniPdf/

Could you provide your environment, version, OS

[Tigerhawk007]

Thanks for getting back to me.

OS: Windows 11 Pro ver 10.0.26200 Build 26200
Dev Env: Visual Stuido 2022 ver 17.17.33

Developing with C# using the 0.29.0 version of MiniPdf

Just noticed that you have a 0.30 version, so I'm updating that to see if that resolves my issue.

[Tigerhawk007]

Updating didn't seem to make a difference. From my code it is still creating a 1 kb single blank page PDF. Below is how I have it implemented.

    internal static void ExcelToPDF(AppSettings appSettings, string xlFname, ref Logging log)
    {

        string pdfName = xlFname.Replace("xlsx", "pdf");
        MiniPdf.ConvertToPdf(xlFname, pdfName);

[shps951023]

I verified this again with the file you uploaded.

using MiniSoftware;

var xlFname = Path.GetFullPath(args.Length > 0 ? args[0] : @"..\..\tests\Issue_Files\xlsx\XlsxIssue75.xlsx");
var pdfName = xlFname.Replace("xlsx", "pdf");

MiniPdf.ConvertToPdf(xlFname, pdfName);

var pdfInfo = new FileInfo(pdfName);
Console.WriteLine(pdfInfo.FullName);
Console.WriteLine(pdfInfo.Length);

Could you please confirm that the XLSX file is fully saved and closed before calling MiniPdf.ConvertToPdf? If the Excel file is generated in the same process, please make sure the workbook/package/stream is disposed or closed before conversion.

Or you can provide project zip

[Tigerhawk007]

I have verified that the XLSX file has been saved. Here is the function that creates the XLSX file then calls the ExcelToPDF function.

    internal static void WriteFile(AppSettings appSettings, string fName, DataTable dt, bool createPDF, ref Logging log)
    {
        try
        {
            // Removes the Row_ID column that was generated on import. Not needed in the output.
            // Requested to add ROW_ID back to the output 2025.04.10 per conversation with Ann and Sukhwinder.
            //dt.Columns.Remove("Row_ID");

            using (var wb = new XLWorkbook())
            {
                var ws = wb.Worksheets.Add("Sheet1");
                var extbl = ws.Cell(1, 1).InsertTable(dt);
                extbl.Theme = XLTableTheme.None;
                ws.Columns().AdjustToContents();
                wb.SaveAs(appSettings.fileOutputPathUnformated + fName);
                var headerRange = extbl.HeadersRow().AsRange();
                headerRange.Style.Font.Bold = true;
                headerRange.Style.Fill.BackgroundColor = XLColor.LightGray;
                ws.Columns().AdjustToContents();
                wb.SaveAs(appSettings.fileOutputPathFormated + fName);
            }
            if (createPDF)
            {
                ExcelToPDF(appSettings, appSettings.fileOutputPathFormated + fName, ref log);
            }

            //var wb = new XLWorkbook();
            //wb.Worksheets.Add(dt, "Sheet1");

            //wb.SaveAs(fName);

        }
        catch (Exception ex)
        {
            log.LogErr(ex.Message);
            //MessageBox.Show(ex.Message);
        }
    }

[shps951023]

@Tigerhawk007 Please try latest version

[KsanderVine]

I am facing the same issue on the latest (0.37.2) version of the library. Without options specified, it generates a blank PDF. When options are provided, it throws an exception because the library cannot find any worksheets inside the file. Original file generated with ClosedXML.

I am using MiniPdf.ConvertToPdf(inputPath, opts) with the following options:

MiniPdfConversionOptions opts = new MiniPdfConversionOptions
{
    SheetIndexes = [1]
};

This throws the following exception:

System.ArgumentException: 'Sheet index(es) out of range: 1. Available index range: none. (Parameter 'selectedSheetIndexes')'

[ItzelRendon]

I'm having the same issue. I generate an Excel file and then convert it to PDF, but the PDF ends up blank.
If I manually open the Excel file, save it without making any changes, and run the conversion again, the PDF generates correctly with the expected data.

I'm using the lastest 0.37.2
Windows 11 Pro Ver 25H2 Build 26200.8457
Microsoft Visual Studio Community 2019 Ver 16.11.57 VisualStudio.16.Release/16.11.57+37327.17

[Tigerhawk007]

Sorry I had another project that pulled me away from this one. I tested the latest version and still seeing the same issue. As a few others have noted it appears that the conversion process is not seeing the sheet in the file.

[shps951023]

@KsanderVine @ItzelRendon @Tigerhawk007 could you please try lastest version?
thanks!