Convert Excel Spreadsheet to PDF using C#

readme.md

Related blog post: How to Convert Excel Spreadsheets using C#

ConvertExcelSheetRangeToPDF.cs

/*
 * Convert the specified Cell Range of specified Excel sheets to PDF format using C#
 */
// Prepare Load options and Range for the source XLSX file
Func<LoadOptions> loadOptions = () => new SpreadsheetLoadOptions
{
    ConvertRange = "A1:C20"
};
using (var converter = new Converter(@"path/spreadsheet.xlsx", loadOptions))
{
    var convertOptions = new PdfConvertOptions()
    {
        PageNumber = 2,
        PagesCount = 3
        // Pages = new System.Collections.Generic.List<int> { 2,3,4}
    };
    // Save as PDF after conversion
    converter.Convert(@"path/cell-range-converted.pdf", convertOptions);
}

ConvertExcelToPDF.cs

/*
 * Convert all the Excel sheets to PDF format using C#
 */
// Prepare Load options and Range for the source XLSX file
Func<LoadOptions> loadOptions = () => new SpreadsheetLoadOptions
{
    OnePagePerSheet = true
};
using (var converter = new GroupDocs.Conversion.Converter(@"path/spreadsheet.xlsx", loadOptions))
{
    // Convert and save the spreadsheet in PDF format
    converter.Convert(@"path/all-sheets-converted.pdf", new PdfConvertOptions());
}

ConvertSheetSequenceToPDF.cs

/*
 * Convert sequence of Excel sheets to PDF format using C#
 */
using (var converter = new GroupDocs.Conversion.Converter(@"path/spreadsheet.xlsx"))
{
    // Set the starting sheet number and consecutive sheet count
    var convertOptions = new PdfConvertOptions()
    {
        PageNumber = 2,
        PagesCount = 3
    };
    // Convert and save the spreadsheet in PDF format
    converter.Convert(@"path/sequential-sheets-converted.pdf", convertOptions);
}

ConvertSpecifiedSheetsToPDF.cs

/*
 * Convert the specified list of Excel sheets to PDF format using C#
 */
using (var converter = new GroupDocs.Conversion.Converter(@"path/spreadsheet.xlsx"))
{
    // Set the list to sheet numbers on convert
    var convertOptions = new PdfConvertOptions()
    {
        Pages = new System.Collections.Generic.List<int> { 1,3,5}
    };
    // Convert and save the spreadsheet into PDF format
    converter.Convert(@"path/selected-sheets-conversion.pdf", convertOptions);
}