GdPicture.NET.14
GdPicture14 Namespace / GdPictureDocumentConverter Class / SpreadsheetRenderOnlyPrintArea Property
Example





In This Topic
SpreadsheetRenderOnlyPrintArea Property (GdPictureDocumentConverter)
In This Topic
For spreadsheet, specifies that for each sheets only the print areas must be rendered. If no print area are found the whole sheets will be rendered
Syntax
'Declaration
 
Public Property SpreadsheetRenderOnlyPrintArea As Boolean
 

Property Value

The default value is false.
Example
Loading and converting a .xlsx with SpreadsheetRenderOnlyPrintArea enabled.
Using gdpictureDocumentConverter As New GdPictureDocumentConverter()
    gdpictureDocumentConverter.SpreadsheetRenderOnlyPrintArea = True
    Dim status As GdPictureStatus = gdpictureDocumentConverter.LoadFromFile("test_xlsx.xlsx", GdPicture14.DocumentFormat.DocumentFormatXLSX)
    If status = GdPictureStatus.OK Then
        MessageBox.Show("The file has been loaded successfully.", "GdPicture")
        status = gdpictureDocumentConverter.SaveAsPDF("Converted.pdf", PdfConformance.PDF)
        If status = GdPictureStatus.OK Then
            MessageBox.Show("The file has been saved successfully.", "GdPicture")
        Else
            MessageBox.Show("The file has failed to save. Status: " + status.ToString(), "GdPicture")
        End If
    Else
        MessageBox.Show("The file has failed to load. Status: " + status.ToString(), "GdPicture")
    End If
End Using
See Also