Allows to set page size for output PDF document

Namespace:  SautinSoft
Assembly:  SautinSoft.ExcelToPdf (in SautinSoft.ExcelToPdf.dll) Version: 4.2.7.24

Syntax

      
 C#  Visual Basic 
public class CPageSize
Public Class CPageSize

Members

         
 All Members  Constructors   Methods  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
ExcelToPdf..::.CPageStyle..::.CPageSize()()()
Creates an instance of ExcelToPdf..::.CPageStyle..::.CPageSize
A3()()()
Set A3 page size, 297 x 420 mm, 11.69 x 16.54 In
A4()()()
Set A4 page size, 210 x 297 mm, 8.26 x 11.69 In
A5()()()
Set A5 page size, 148 x 210 mm, 5.82 x 8.26 In
A6()()()
Set A6 page size, 105 x 148 mm, 4.13 x 5.82 In
Auto()()()
Auto-detect page size from work-area of Excel worksheet
B5Iso()()()
Set B5Iso page size, 176 x 250 mm, 6.93 x 9.83 In
B5Jis()()()
Set B5Jis page size, 182 x 257 mm, 7.16 x 10.11 In
B6()()()
Set B6 page size, 128 x 182 mm, 5.04 x 7.16 In
Executive()()()
Set Executive page size, 184 x 267 mm, 7.25 x 10.5 In
Folio()()()
Set Folio page size, 210 x 330 mm, 8.26 x 12.99 In
HeightInch(Single)
Set page height in inches
Heightmm(Single)
Set page height in mm
Legal()()()
Set Legal page size, 216 x 356 mm, 8.5 x 14 In
Letter()()()
Set Letter size, 216 x 279 mm, 8.5 x 11 In. This is default value.
Oficio2()()()
Set Oficio2 page size, 216 x 330 mm, 8.5 x 13 In
Statement()()()
Set Statement page size, 140 x 216 mm, 5.5 x 8.5 In
WidthInch(Single)
Set page width in inches
Widthmm(Single)
Set page width in mm

Remarks

Examples

CopySpecify page size and margins for the output PDF document in C#
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, A4 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(pdfFile);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                Console.ReadLine();
            }

        }
    }
}
CopySpecify page size and margins for the output PDF document in VB.Net
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, A4 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(pdfFile)
        Catch ex As Exception
            Console.WriteLine(ex.Message)
            Console.ReadLine()
        End Try

    End Sub
End Module

Inheritance Hierarchy

System..::.Object
  SautinSoft..::.ExcelToPdf..::.CPageStyle..::.CPageSize

See Also