Allows to set page margins in mm and inches
Namespace:
SautinSoftAssembly: SautinSoft.ExcelToPdf (in SautinSoft.ExcelToPdf.dll) Version: 5.0.11.20
Syntax
C# | Visual Basic |
public class CPageMargin
Public Class CPageMargin
Members
All Members | Constructors ![]() | Methods ![]() |
![]() ![]() | ![]() ![]() ![]() | ![]() ![]() | ![]() ![]() ![]() ![]() |
Member | Description | |
---|---|---|
![]() | ExcelToPdf..::.CPageStyle..::.CPageMargin()()() |
Creates a new instance of ExcelToPdf..::.CPageStyle..::.CPageMargin class
|
![]() | Inch(Single) |
Set value of page margin in inches
|
![]() | mm(Single) |
Set value of page margin in mm
|
Remarks

Examples

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(); } } } }

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