Table of Contents

FlexCelPdfExport.ExportAllVisibleSheets Method

Overloads

FlexCelPdfExport.ExportAllVisibleSheets(Boolean, String)

This method will export all the visible sheets on an xls file to pdf. Different than calling ExportSheet for each sheet, this method can keep the page number growing on each sheet, without resetting it.

Syntax

Namespace: FlexCel.Render

public virtual void ExportAllVisibleSheets(Boolean resetPageNumberOnEachSheet, String bookmarkName)

Parameters

<-> Parameter Type Description
resetPageNumberOnEachSheet Boolean If true, each new sheet will reset the page number shown on Excel headers and footers.
bookmarkName String If not null, each sheet will be added as an entry on the Bookmarks in the pdf file, under the name specified here.
If you want the Bookmark window to be visible when you open the pdf file, set PdfWriter.PageLayout = TPageLayout Also, use the GetBookmarkInformation event to further customize what goes in each of the entries.

See also

FlexCelPdfExport.ExportAllVisibleSheets(String, Boolean, String)

This method will export all the visible sheets on an xls file to pdf. This method is a shortcut for creating a filestream, calling BeginExport on the filestream, calling ExportAllVisibleSheets(Boolean, String) and then calling EndExport.

Syntax

Namespace: FlexCel.Render

public virtual void ExportAllVisibleSheets(String fileName, Boolean resetPageNumberOnEachSheet, String bookmarkName)

Parameters

<-> Parameter Type Description
fileName String File where the file will be saved.
resetPageNumberOnEachSheet Boolean If true, each new sheet will reset the page number shown on Excel headers and footers.
bookmarkName String If not null, each sheet will be added as an entry on the Bookmarks in the pdf file, under the name specified here.
If you want the Bookmark window to be visible when you open the pdf file, set PdfWriter.PageLayout = TPageLayout Also, use the GetBookmarkInformation event to further customize what goes in each of the entries.

See also