RenderSheetHeadersAndFooters Property (GdPictureDocumentConverter)

In This Topic

Specifies that the xls and xlsx headers and footers should be rendered.

Syntax

Visual Basic
C#
Delphi
JScript
Managed Extensions for C++
C++/CLI

'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.

VB.NET
C#

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

Reference

GdPictureDocumentConverter Class
GdPictureDocumentConverter Members