Example





In This Topic
GdPicture14 Namespace / GdPictureDocumentConverter Class / RenderSheetHeadersAndFooters Property

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