ExcelToPdfCSheetPrintedAreaAdd(Int32, Int32, Int32, Int32, Int32) Method

Adds custom area to export in PDF, Word by column and row numbers.

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

Syntax

public void Add(
	int Col1,
	int Row1,
	int Col2,
	int Row2,
	int[]? SheetNums = null
)

Public Sub Add ( 
	Col1 As Integer,
	Row1 As Integer,
	Col2 As Integer,
	Row2 As Integer,
	Optional SheetNums As Integer() = Nothing
)

Parameters

Col1 Int32: Top cell number
Row1 Int32: Top row number
Col2 Int32: Bottom cell number
Row2 Int32: Bottom row number
SheetNums Int32 (Optional): Array with sheets numbers

Example

Copy

SautinSoft.ExcelToPdf x = new SautinSoft.ExcelToPdf();
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf;
int[] arJ = { 1 };
x.Sheets.PrintArea.Add(1, 20, 4, 25, arJ); // same as x.Sheets.PrintArea.Add("A20", "D25", arJ);

Dim x As New SautinSoft.ExcelToPdf()
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf;
Dim arJ() As Integer = { 1 }
x.Sheets.PrintArea.Add(20, 1, 25, 4, arJ)

Reference

ExcelToPdfCSheetPrintedArea Class

Add Overload

SautinSoft Namespace