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





In This Topic
RenderSheetHeadersAndFooters Property (GdPictureDocumentConverter)
In This Topic
Specifies that the xls and xlsx headers and footers should be rendered.
Syntax
'Declaration
 
Public Property RenderSheetHeadersAndFooters As Boolean
public bool RenderSheetHeadersAndFooters {get; set;}
public read-write property RenderSheetHeadersAndFooters: Boolean; 
public function get,set RenderSheetHeadersAndFooters : boolean
public: __property bool get_RenderSheetHeadersAndFooters();
public: __property void set_RenderSheetHeadersAndFooters( 
   bool value
);
public:
property bool RenderSheetHeadersAndFooters {
   bool get();
   void set (    bool value);
}

Property Value

The default value is false.
Example
Loading and converting a .xlsx document rendering headers and footers.
Using gdpictureDocumentConverter As New GdPictureDocumentConverter()
    gdpictureDocumentConverter.RenderSheetHeadersAndFooters = True
    Dim status As GdPictureStatus = gdpictureDocumentConverter.LoadFromFile("test_xlsx.xlsxx", 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
using (GdPictureDocumentConverter gdpictureDocumentConverter = new GdPictureDocumentConverter())
{
    gdpictureDocumentConverter.RenderSheetHeadersAndFooters = true;
    GdPictureStatus status = gdpictureDocumentConverter.LoadFromFile("test_xlsx.xlsx", GdPicture14.DocumentFormat.DocumentFormatXLSX);
    if (status == GdPictureStatus.OK)
    {
        MessageBox.Show("The file has been loaded successfully.", "GdPicture");
        status = gdpictureDocumentConverter.SaveAsPDF("Converted.pdf", PdfConformance.PDF);
        if (status == GdPictureStatus.OK)
        {
            MessageBox.Show("The file has been saved successfully.", "GdPicture");
        }
        else
        {
            MessageBox.Show("The file has failed to save. Status: " + status.ToString(), "GdPicture");
        }
    }
    else
    {
        MessageBox.Show("The file has failed to load. Status: " + status.ToString(), "GdPicture");
    }
}
See Also