Click or drag to resize

ExcelToPdfCPageStyleCPageSize Class

Allows to set page size for output PDF document. Default option: Auto
Inheritance Hierarchy
SystemObject
  SautinSoftExcelToPdfCPageStyleCPageSize

Namespace: SautinSoft
Assembly: SautinSoft.ExcelToPdf (in SautinSoft.ExcelToPdf.dll) Version: 2023.11.22
Syntax
Copy
public class CPageSize

The ExcelToPdfCPageStyleCPageSize type exposes the following members.

Constructors
 NameDescription
Public methodExcelToPdfCPageStyleCPageSize Creates an instance of ExcelToPdfCPageStyleCPageSize
Top
Methods
 NameDescription
Public methodA3 Set A3 page size, 297 x 420 mm, 11.69 x 16.54 In
Public methodA4 Set A4 page size, 210 x 297 mm, 8.26 x 11.69 In
Public methodA5 Set A5 page size, 148 x 210 mm, 5.82 x 8.26 In
Public methodA6 Set A6 page size, 105 x 148 mm, 4.13 x 5.82 In
Public methodAuto Auto-detect page size from work-area of Excel worksheet
Public methodB5Iso Set B5Iso page size, 176 x 250 mm, 6.93 x 9.83 In
Public methodB5Jis Set B5Jis page size, 182 x 257 mm, 7.16 x 10.11 In
Public methodB6 Set B6 page size, 128 x 182 mm, 5.04 x 7.16 In
Public methodEqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
Public methodExecutive Set Executive page size, 184 x 267 mm, 7.25 x 10.5 In
Public methodFolio Set Folio page size, 210 x 330 mm, 8.26 x 12.99 In
Public methodGetHashCodeServes as the default hash function.
(Inherited from Object)
Public methodGetTypeGets the Type of the current instance.
(Inherited from Object)
Public methodHeightInch Set page height in inches
Public methodHeightmm Set page height in mm
Public methodLegal Set Legal page size, 216 x 356 mm, 8.5 x 14 In
Public methodLetter Set Letter size, 216 x 279 mm, 8.5 x 11 In.
Public methodOficio2 Set Oficio2 page size, 216 x 330 mm, 8.5 x 13 In
Public methodStatement Set Statement page size, 140 x 216 mm, 5.5 x 8.5 In
Public methodToStringReturns a string that represents the current object.
(Inherited from Object)
Public methodWidthInch Set page width in inches
Public methodWidthmm Set page width in mm
Top
Example
Specify page size and margins for the output PDF document in C#
Copy
using System;
using System.IO;
using SautinSoft;

namespace Sample
{
    class Sample
    {
        static void Main(string[] args)
        {
            // Specify page size and margins.
            ExcelToPdf x = new ExcelToPdf();

            //Fit each sheet to single PDF page, A3 format.
            x.PageStyle.PageSize.A3();
            x.PageStyle.PageScale.Auto();
            x.PageStyle.PageOrientation.Landscape();
            x.PageStyle.PageMarginTop.mm(0);            

            // Set PDF as output format.
            x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf;

            string excelFile = Path.GetFullPath(@"..\..\..\test.xlsx");
            string pdfFile = Path.ChangeExtension(excelFile, ".pdf"); ;

            try
            {
                x.ConvertFile(excelFile, pdfFile);
                System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(pdfFile) { UseShellExecute = true });
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                Console.ReadLine();
            }
        }
    }
}
Specify page size and margins for the output PDF document in VB.Net
Copy
Imports System
Imports System.IO
Imports SautinSoft

Module Sample

    Sub Main()
        ' Specify page size and margins.
        Dim x As New ExcelToPdf()

        'Fit each sheet to single PDF page, A3 format.
        x.PageStyle.PageSize.A3()
        x.PageStyle.PageScale.Auto()
        x.PageStyle.PageOrientation.Landscape()
        x.PageStyle.PageMarginTop.mm(0)

        ' Set PDF as output format.
        x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf

        Dim excelFile As String = Path.GetFullPath("..\..\..\test.xlsx")
        Dim pdfFile As String = Path.ChangeExtension(excelFile, ".pdf")

        Try
            x.ConvertFile(excelFile, pdfFile)
            System.Diagnostics.Process.Start(New System.Diagnostics.ProcessStartInfo(pdfFile) With {.UseShellExecute = True})
        Catch ex As Exception
            Console.WriteLine(ex.Message)
            Console.ReadLine()
        End Try
    End Sub
End Module
See Also