ImageGear .NET v25.0 - Updated
Repaginate(Double,Double,ImGearExcelPageOrder,Boolean) Method




ImageGear.Formats.Office Assembly > ImageGear.Formats.Office Namespace > ImGearExcelBookPage Class > Repaginate Method : Repaginate(Double,Double,ImGearExcelPageOrder,Boolean) Method
The desired width of the page in pixels.
The desired height of the page in pixels.
The desired order of the pages contained in the ImGearExcelSheetDocument returned by this method.
The flag indicating that only cells within Print Area should be paginated, if that range is defined.
Forces pagination of the sheet's content and returns a new ImGearExcelSheetDocument object containing the new pages.
Syntax
'Declaration
 
Public Overloads Function Repaginate( _
   ByVal pageWidth As Double, _
   ByVal pageHeight As Double, _
   ByVal pageOrder As ImGearExcelPageOrder, _
   ByVal usePrintArea As Boolean _
) As ImGearExcelSheetDocument
'Usage
 
Dim instance As ImGearExcelBookPage
Dim pageWidth As Double
Dim pageHeight As Double
Dim pageOrder As ImGearExcelPageOrder
Dim usePrintArea As Boolean
Dim value As ImGearExcelSheetDocument
 
value = instance.Repaginate(pageWidth, pageHeight, pageOrder, usePrintArea)

Parameters

pageWidth
The desired width of the page in pixels.
pageHeight
The desired height of the page in pixels.
pageOrder
The desired order of the pages contained in the ImGearExcelSheetDocument returned by this method.
usePrintArea
The flag indicating that only cells within Print Area should be paginated, if that range is defined.

Return Value

A new ImGearExcelSheetDocument instance.
Exceptions
ExceptionDescription
Thrown if either of provided page dimensions are not sufficient to represent any content, including page margins.
Remarks

Page dimensions of the sheet can be stored in the SpreadsheetML package. ImageGear retrieves them (if any) and applies upon loading of the document. If no page dimensions are defined within the package, the default letter size of 8.5"(width) x 11"(height) (1" is equal to 96 pixels) will be used.

Set both pageWidth and pageHeight parameters to 0 to use available page dimensions in the document or the default letter size.

If valid (non-zero) dimensions are supplied in the pageWidth and pageHeight parameters, then any page dimensions defined in the original Excel document are ignored and the parameter values are used.

The default page dimensions are 816 x 1056 pixels.

See Also

Reference

ImGearExcelBookPage Class
ImGearExcelBookPage Members
Overload List