Table of Contents

TFlexCelPrintDocument.PrintAllVisibleSheets Method

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

Syntax

Unit: FlexCel.Render

procedure TFlexCelPrintDocument.PrintAllVisibleSheets(const resetPageNumberOnEachSheet: Boolean; startPageToPrint: Integer = 1; totalPagesToPrint: Integer = -1); virtual;

Parameters

<-> Parameter Type Description
const resetPageNumberOnEachSheet Boolean If true, each new sheet will reset the page number shown on Excel headers and footers.
startPageToPrint Integer Optional: Default value is 1

First page on the file to print (first page is 1).
totalPagesToPrint Integer Optional: Default value is -1

How many pages will be printed. If you specify a negative number here (the default), all pages from startPageToPrint will be printed.

See also