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