PDF Export Options

// Create a new workbook.
var workbook = new Workbook();

// Open template file.
workbook.Open("CustomBorderStyle.xlsx");

// Customize the border style for PDF export.
// Initialize PdfSaveOptions.
var pdfSaveOptions = new PdfSaveOptions();
            
// Set outer border width to 0.4.
var thinBorderSetting = new CustomBorderStyle { BorderWidth = 0.4 };

// Set middle border width to 1.5.
var middleBorderSetting = new CustomBorderStyle { BorderWidth = 1.5 };

// Set inner horizontal border width to 0.4 in dash style.
var dashBorderSetting = new CustomBorderStyle { BorderWidth = 0.4, Dashes = new List<double> { 0.8, 0.8 } };

// Add borders with custom border styles.
pdfSaveOptions.BorderOptions.Add(BorderLineStyle.Thin, thinBorderSetting);
pdfSaveOptions.BorderOptions.Add(BorderLineStyle.Medium, middleBorderSetting);
pdfSaveOptions.BorderOptions.Add(workbook.ActiveSheet.Range["B13"].Borders[BordersIndex.EdgeTop].LineStyle, dashBorderSetting);
            
// Save workbook to PDF file.
workbook.Save("CustomBorder.pdf", pdfSaveOptions);

// Create a PDF file stream.
using FileStream outputStream =
    new FileStream("ShrinkToFitForWrappedText.pdf", FileMode.Create);

// Create a new workbook.
var workbook = new GrapeCity.Documents.Excel.Workbook();
IWorksheet worksheet = workbook.Worksheets[0];

worksheet.PageSetup.PrintGridlines = true;
worksheet.PageSetup.PrintHeadings = false;

// Configure the table layout.
worksheet.Range["A:B"].ColumnWidth = 14;
worksheet.Range["1:1"].RowHeight = 30;
worksheet.Range["2:2"].RowHeight = 32;

// Add the table headers.
worksheet.Range["A1:B1"].Value = new object[,]
{
    { "Wrapped Text", "Shrink-to-Fit Wrapped Text" }
};
worksheet.Range["A1:B1"].Font.Bold = true;
worksheet.Range["A1:B1"].WrapText = true;
worksheet.Range["A1:B1"].HorizontalAlignment = HorizontalAlignment.Center;
worksheet.Range["A1:B1"].VerticalAlignment = VerticalAlignment.Center;

// Add the comparison content horizontally.
worksheet.Range["A2:B2"].Value = new object[,]
{
    {
        "Document Solutions for Excel",
        "Document Solutions for Excel"
    }
};
worksheet.Range["A2:B2"].WrapText = true;
worksheet.Range["A2:B2"].VerticalAlignment = VerticalAlignment.Center;

// Shrink the wrapped text in B2 to fit the existing cell size.
worksheet.Range["B2"].ShrinkToFit = true;

// Enable Shrink to Fit for wrapped text during PDF export.
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.ShrinkToFitSettings.CanShrinkToFitWrappedText = true;

// Optional settings.
// pdfSaveOptions.ShrinkToFitSettings.MinimumFont = 10;
// pdfSaveOptions.ShrinkToFitSettings.Ellipsis = "~";

// Save the workbook to PDF.
workbook.Save(outputStream, pdfSaveOptions);

public void SavePDFPdfSecurityOptions()
{
    // Initialize workbook
    Workbook workbook = new Workbook();
    // Fetch default worksheet 
    IWorksheet worksheet = workbook.Worksheets[0];
    // Data
    object[,] data = new object[,]{
 {"Name", "City", "Birthday", "Sex", "Weight", "Height", "Age"},
 {"Bob", "NewYork", new DateTime(1968, 6, 8), "male", 80, 180, 56},
 {"Betty", "NewYork", new DateTime(1972, 7, 3), "female", 72, 168, 45},
 {"Gary", "NewYork", new DateTime(1964, 3, 2), "male", 71, 179, 50},
 {"Hunk", "Washington", new DateTime(1972, 8, 8), "male", 80, 171, 59},
 {"Cherry", "Washington", new DateTime(1986, 2, 2), "female", 58, 161, 34},
 {"Coco", "Virginia", new DateTime(1982, 12, 12), "female", 58, 181, 45},
 {"Lance", "Chicago", new DateTime(1962, 3, 12), "female", 49, 160, 57},
 { "Eva", "Washington", new DateTime(1993, 2, 5), "female", 71, 180, 81}};
    // Set data
    worksheet.Range["A1:G9"].Value = data;

    //The security settings of pdf when converting excel to pdf
    PdfSecurityOptions securityOptions = new PdfSecurityOptions();
    //Sets the user password
    securityOptions.UserPassword = "user";
    //Sets the owner password
    securityOptions.OwnerPassword = "owner";
    //Printing the pdf document is not allowed
    securityOptions.PrintPermission = false;
    //Filling the form fields of the pdf document is not allowed
    securityOptions.FillFormsPermission = false;

    PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
    //Sets the security settings of the pdf
    pdfSaveOptions.SecurityOptions = securityOptions;

    // Saving workbook to PDF
    workbook.Save(@"4-SavePDFPdfSecurityOptions.pdf", pdfSaveOptions);
}

// Create a pdf file stream
FileStream outputStream = new FileStream("setdocumentpropertiestopdf.pdf", FileMode.Create);

// Create a new workbook
var workbook = new GrapeCity.Documents.Excel.Workbook();

IWorksheet worksheet = workbook.Worksheets[0];
worksheet.Range["A1"].Value = "Documents for Excel";
worksheet.Range["A1"].Font.Size = 25;

DocumentProperties documentProperties = new DocumentProperties
{
    // Sets the name of the person that created the PDF document.
    Author = "Jaime Smith",
    // Sets the title of the  PDF document.
    Title = "GcPdf Document Info Sample",
    // Do not embed a font.
    EmbedStandardWindowsFonts = false,
    // Set the PDF version.
    PdfVersion = 1.5f,
    // Set the subject of the PDF document.
    Subject = "GcPdfDocument.DocumentInfo",
    // Set the keyword associated with the PDF document.
    Keywords = "Keyword1",
    // Set the creation date and time of the PDF document.
    CreationDate = DateTime.Now.AddYears(10),
    // Set the date and time the PDF document was most recently modified.
    ModifyDate = DateTime.Now.AddYears(11),
    // Set the name of the application that created the original PDF document.
    Creator = "GcPdfWeb Creator",
    // Set the name of the application that created the PDF document.
    Producer = "GcPdfWeb Producer"
};

PdfSaveOptions pdfSaveOptions = new PdfSaveOptions
{
    // Sets the document properties of the pdf.
    DocumentProperties = documentProperties
};

// Save the workbook into pdf file.
workbook.Save(outputStream, pdfSaveOptions);
        
// Close the pdf stream
outputStream.Close();

// Initialize workbook.
Workbook workbook = new Workbook();
// Fetch default worksheet 
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.Range["A1"].Value = "Document Solutions for Excel";
worksheet.Range["A1"].Font.Size = 25;

using (FileStream pictureStream = File.Open(@"background-image.png", FileMode.Open, FileAccess.Read))
{
    MemoryStream pictureMemoryStream = new MemoryStream();
    pictureStream.CopyTo(pictureMemoryStream);
    byte[] picturebytes = pictureMemoryStream.ToArray();

    //Add background image of the worksheet
    worksheet.BackgroundPicture = picturebytes;
}
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();

// Print the background picture in the centre of exported pdf file.
pdfSaveOptions.PrintBackgroundPicture = true;

// Saving workbook to pdf.
workbook.Save(@"PrintBackgroundPicture.pdf", pdfSaveOptions);

// Initialize workbook.
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.Worksheets[0];

// Add two background pictures in the worksheet
IBackgroundPicture picture1 = worksheet.BackgroundPictures.AddPictureInPixel("logo.png", 100, 100, 350, 250);
IBackgroundPicture picture2 = worksheet.BackgroundPictures.AddPictureInPixel("watermark.png", 180, 10, 150, 100);

// Set the border style of the destination rectangle
picture1.Line.Color.RGB = Color.Gray;
picture1.Line.Weight = 1;

// The background picture will be resized to fill the destination dimensions.The aspect ratio is not preserved.
picture1.BackgroundImageLayout = ImageLayout.Stretch;

// Sets the rounded corner of the destination rectangle.
picture1.CornerRadius = 50;

// Sets the transparency of the background pictures.
picture1.Transparency = 0.5;
picture2.Transparency = 0.5;

// Save to PDF file.
workbook.Save("ExportBackgroundImageToPDF.pdf");

// Initialize workbook.
Workbook workbook = new Workbook();

// Fetch default worksheet.
IWorksheet worksheet = workbook.Worksheets[0];

// Set the background color of range ["A1:K20"].
worksheet.Range["A1:K20"].Interior.Color = System.Drawing.Color.FromArgb(50, 255, 0, 0);

// Add a background picture.
IBackgroundPicture picture = worksheet.BackgroundPictures.AddPictureInPixel("image.png", 0, 0, 300, 200);

// Set the transparency of cell's background color, so the background picture will come out to the front.
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.PrintTransparentCell = true;

// Save to pdf file.
workbook.Save("PrintTransparentCell.pdf", pdfSaveOptions);

// Create a pdf file stream.
FileStream outputStream = new FileStream("pageprinteventstrackprogress.pdf", FileMode.Create);

// Create a new workbook.
var workbook = new Workbook();

var activeSheet = workbook.ActiveSheet;
activeSheet.Range["A1"].Value = 1;
activeSheet.Range["A2:A100"].FormulaR1C1 = "=R[-1]C+1";
var options = new PdfSaveOptions();
options.PagePrinting += (sender, e) =>
Console.WriteLine($"Printing page {e.PageNumber} of {e.PageCount}");
activeSheet.PageSetup.CenterHeader = "Page &P of &N";
workbook.Save(outputStream, options);

// Close the pdf stream.
outputStream.Close();

// Create a pdf file stream.
FileStream outputStream = new FileStream("pageprinteventsskippage.pdf", FileMode.Create);

// Create a new workbook.
var workbook = new GrapeCity.Documents.Excel.Workbook();

var activeSheet = workbook.ActiveSheet;
activeSheet.Range["A1"].Value = 1;
activeSheet.Range["A2:A100"].FormulaR1C1 = "=R[-1]C+1";
var options = new PdfSaveOptions();

// skip second page.
options.PagePrinting += (sender, e) =>
{
    if (e.PageNumber == 2)
    {
        e.SkipThisPage = true;
    }
};
activeSheet.PageSetup.CenterHeader = "Page &P of &N";
workbook.Save(outputStream, options);

// Close the pdf stream
outputStream.Close();

// Create a pdf file stream.
FileStream outputStream = new FileStream("pageprinteventsexitprinting.pdf", FileMode.Create);

// Create a new workbook.
var workbook = new GrapeCity.Documents.Excel.Workbook();

var activeSheet = workbook.ActiveSheet;
activeSheet.Range["A1"].Value = 1;
activeSheet.Range["A2:A100"].FormulaR1C1 = "=R[-1]C+1";
var options = new PdfSaveOptions();

// Exit printing after second page.
options.PagePrinted += (sender, e) =>
{
    if (e.PageNumber == 2)
    {
        e.HasMorePages = false;
    }
};
activeSheet.PageSetup.CenterHeader = "Page &P of &N";
workbook.Save(outputStream, options);

// Close the pdf stream.
outputStream.Close();

Workbook workbook = new Workbook();
workbook.Open("SampleTemplate.xlsx");

workbook.ProcessTemplate();
PdfSaveOptions options = new PdfSaveOptions();
        
// Set JavaScript.
options.OpenActionScript = "var fld1 = this.getField(\"num\");" +
"fld1.value = fld1.value;" +
"this.dirty = false;";

workbook.Save("SampleTemplate.pdf", options);

// Initialize workbook.
Workbook workbook = new Workbook();
// Fetch default worksheet
IWorksheet worksheet = workbook.Worksheets[0];

// Add a picture.
worksheet.Shapes.AddPictureInPixel("Logo.png", 0, 0, 639, 578);

// Create PdfSaveOptions.
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();

// Set image quality as 100 % (highest quality).
pdfSaveOptions.ImageQuality = 100;

// Save to pdf with PdfSaveOptions.
workbook.Save("LogoInPDF.pdf", pdfSaveOptions);

// Create workbook and add two sheets.
Workbook workbook = new Workbook();
IWorksheet sheet1 = workbook.Worksheets[0];
IWorksheet sheet2 = workbook.Worksheets.Add();

// Set style.
sheet1.Range["A1"].Value = "Sheet1";
sheet1.Range["A1"].Font.Name = "Wide Latin";
sheet1.Range["A1"].Font.Color = Color.Red;
sheet1.Range["A1"].Interior.Color = Color.Green;

// Create a table in sheet1.
sheet1.Tables.Add(sheet1.Range["C1:E5"], true);

sheet2.Range["A1"].Value = "Sheet2";

// Specify font path.
Workbook.FontsFolderPath = @"D:\Fonts";

// Get the used fonts list in workbook, the list are:"Wide Latin", "Calibri"
var fonts = workbook.GetUsedFonts();

// Export workbook to pdf file, the exported file has two pages.
workbook.Save(@"D:\workbook.pdf", SaveFileFormat.Pdf);

// Just export sheet1 to pdf file.
sheet1.Save(@"D:\sheet1.pdf", SaveFileFormat.Pdf);