Page 1 of 1
PrintSettings.RowsOnEachPage
Posted: Tue Sep 18, 2007 4:51 pm
by charlesWolfe
In version 1, to have XLS repeat the row(s) on each printed page,
we would use the command:
XLS.Sheets[0].PrintSettings.RowsOnEachPage := '0:'+IntToStr(XLSCurrRow);
What do we use in version 3?
Posted: Wed Sep 19, 2007 7:46 am
by larsa
Hello
Print titles are defined as a name, with the InternalNames property.
Code: Select all
with XLS.InternalNames.Add do begin
// A print area is a built in name; that is, there is no name for it.
BuiltInName := bnPrintTitles;
// The definition area must be absolute.
Definition := 'Sheet1!$A$1:$G$15';
Lars Arvidsson
Posted: Wed Sep 19, 2007 9:30 pm
by charlesWolfe
added stmt, not working, getting excel error when doing print or preview:
Print Titles must be contiguous and complete rows or columns.
print rows on each line.
Posted: Fri Sep 21, 2007 8:57 pm
by charlesWolfe
Must specify Sheet1!$A$1:$IV$5
if you are wanting the first 5 rows to be printed.
Must be $A thru $IV