TFlexCelPdfExport.ExportAllVisibleSheets Method

Overloads

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

Unit: FlexCel.Render

procedure TFlexCelPdfExport.ExportAllVisibleSheets(const resetPageNumberOnEachSheet: Boolean; const bookmarkName: string); overload; virtual;

Parameters

<-> Parameter Type Description
const resetPageNumberOnEachSheet Boolean If true, each new sheet will reset the page number shown on Excel headers and footers.
const 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 TPdfWriter.PageLayout = TPageLayout Also, use the GetBookmarkInformation event to further customize what goes in each of the entries.

See also

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

Unit: FlexCel.Render

procedure TFlexCelPdfExport.ExportAllVisibleSheets(const fileName: string; const resetPageNumberOnEachSheet: Boolean; const bookmarkName: string); overload; virtual;

Parameters

<-> Parameter Type Description
const fileName string File where the file will be saved.
const resetPageNumberOnEachSheet Boolean If true, each new sheet will reset the page number shown on Excel headers and footers.
const 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 TPdfWriter.PageLayout = TPageLayout Also, use the GetBookmarkInformation event to further customize what goes in each of the entries.

See also