Table of Contents

TFlexCelPrintDocument.PrintSheet Method

Overloads

TFlexCelPrintDocument.PrintSheet

Prints the activesheet on the current XlsFile.

Syntax

Unit: FlexCel.Render

procedure TFlexCelPrintDocument.PrintSheet; overload;

See also

TFlexCelPrintDocument.PrintSheet(Integer, Integer, Integer, Integer)

Prints the active sheet on the current XlsFile. You can define which is the first page to print and the global count of pages, so the page numbers on headers and footers of the excel file correspond with the actual pages on the printout.

Syntax

Unit: FlexCel.Render

procedure TFlexCelPrintDocument.PrintSheet(const startPageToDisplay: Integer; totalPagesToDisplay: Integer; startPageToPrint: Integer = 1; totalPagesToPrint: Integer = -1); overload;

Parameters

<-> Parameter Type Description
const startPageToDisplay Integer First page that the headers and footers on the xls file will show. If you are printing only one sheet, this can be 1. If you are exporting more than one sheet in the same process, you will want to set StartPage to the actual page on the printout.
totalPagesToDisplay Integer The total number of pages to display on Excel headers and footers.
If you are printing only one sheet, set it to -1, and it will be calculated automatically.
If not, please supply here the total number of pages the file will have so FlexCel can show footers like "page 1 of 50"
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