using Spire.Xls;

namespace ExcelToPdf
{
    internal class Program
    {
        static void Main(string[] args)
        {
            // Create a Workbook object
            Workbook workbook = new Workbook();
            // Load an Excel file
            workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Example.xlsx");

            // Save the Excel file to PDF
            workbook.SaveToFile("Output.pdf", FileFormat.PDF);
            // Dispose resources
            workbook.Dispose();
        }
    }
}

using Spire.Xls;

namespace WorksheetOrCellRangeToPdf
{
    internal class Program
    {
        static void Main(string[] args)
        {
            // Create a Workbook object
            Workbook workbook = new Workbook();
            // Load the Excel file
            workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Example.xlsx");

            // Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            // Set the print area to a specific cell range
            // Comment this line out if you need to export the entire worksheet as a PDF
            sheet.PageSetup.PrintArea = "B1:E6";

            // Save the cell range as a PDF
            sheet.SaveToPdf("CellRange.pdf");
            // Dispose resources
            workbook.Dispose();
        }
    }
}

using Spire.Xls;

namespace FitWorksheetToOnePage
{
    internal class Program
    {
        static void Main(string[] args)
        {
            // Create a Workbook object
            Workbook workbook = new Workbook();
            // Load the Excel file
            workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Example.xlsx");

            // Fit every worksheet in the workbook to one page
            workbook.ConverterSetting.SheetFitToPage = true;

            // Save the Excel file to PDF
            workbook.SaveToFile("FitToOnePage.pdf", FileFormat.PDF);
            // Dispose resources
            workbook.Dispose();
        }
    }
}

using Spire.Xls;

namespace AdjustPageSetup
{
    internal class Program
    {
        static void Main(string[] args)
        {
            // Create a Workbook object
            Workbook workbook = new Workbook();
            // Load the Excel file
            workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Example.xlsx");

            // Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            // Adjust page setup settings
            // Set page orientation
            sheet.PageSetup.Orientation = PageOrientationType.Landscape;
            // Set paper size
            sheet.PageSetup.PaperSize = PaperSizeType.PaperA4;
            // Set margins
            sheet.PageSetup.LeftMargin = 0.5;
            sheet.PageSetup.RightMargin = 0.5;
            sheet.PageSetup.TopMargin = 0.5;
            sheet.PageSetup.BottomMargin = 0.5;
            // Display Gridlines
            sheet.PageSetup.IsPrintGridlines = true;

            // Save the worksheet as a PDF
            sheet.SaveToPdf("CustomPageSetup.pdf");
            // Dispose resources
            workbook.Dispose();
        }
    }
}

using Spire.Xls;
using Spire.Xls.Pdf.Security;

namespace SecurePdfWithPassword
{
    internal class Program
    {
        static void Main(string[] args)
        {
            // Create a Workbook object
            Workbook workbook = new Workbook();
            // Load the Excel file
            workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Example.xlsx");

            // Set the open and permission passwords for the converted PDF
            workbook.ConverterSetting.PdfSecurity.Encrypt("openPassword", "persmissionPassword", PdfPermissionsFlags.Print, PdfEncryptionKeySize.Key128Bit);

            // Save the Excel file to PDF
            workbook.SaveToFile("SecurePdf.pdf", FileFormat.PDF);
            // Dispose resources
            workbook.Dispose();
        }
    }
}

using Spire.Xls;
using Spire.Xls.Pdf;

namespace ExcelToPdfA
{
    internal class Program
    {
        static void Main(string[] args)
        {
            // Create a Workbook object
            Workbook workbook = new Workbook();
            // Load the Excel file
            workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Example.xlsx");

            // Set the compliance for the converted PDF
            workbook.ConverterSetting.PdfConformanceLevel = PdfConformanceLevel.Pdf_A1A;

            // Save the Excel file to PDF
            workbook.SaveToFile("PdfA_Compliant.pdf", FileFormat.PDF);
            // Dispose resources
            workbook.Dispose();
        }
    }
}

Workbook workbook = new Workbook();
workbook.OpenPassword = "ExcelPassword";
workbook.LoadFromFile("ProtectedExcel.xlsx");
workbook.SaveToFile("Output.pdf", FileFormat.PDF);

string[] files = Directory.GetFiles("ExcelFolder", "*.xlsx");
foreach (string file in files)
{
    Workbook workbook = new Workbook();
    workbook.LoadFromFile(file);
    string outputPath = Path.ChangeExtension(file, ".pdf");
    workbook.SaveToFile(outputPath, FileFormat.PDF);
}

Workbook combinedWorkbook = new Workbook();
combinedWorkbook.Worksheets.Clear();
foreach (string file in Directory.GetFiles("ExcelFolder", "*.xlsx"))
{
    Workbook tempWorkbook = new Workbook();
    tempWorkbook.LoadFromFile(file);
    foreach (Worksheet sheet in tempWorkbook.Worksheets)
    {
        combinedWorkbook.Worksheets.AddCopy(sheet);
    }
}
combinedWorkbook.SaveToFile("Combined.pdf", FileFormat.PDF);