How to set the PrintTitleRows of the PageSetup.

FLX TMS FlexCel for VCL & FMX
1
Hi,
Is it possible to set the PrintTitleRows ?

For example, in VBA....
(It sets the TitleRows. They are printed on all pages.)

    Range("A2:B2").Select
    With ActiveSheet.PageSetup
        .PrintTitleRows = "$1:$2"
        .PrintTitleColumns = ""
    End With

Thanks and best regards,
TARO

2

Hi, 

As mentioned in the other post, you can find out this kind of stuff with APIMate. This is the code I get:



  //Named Ranges
  RangeName := TXlsNamedRange.GetInternalName(TInternalNameRange.Print_Titles);
  Range := TXlsNamedRange.Create(RangeName, 1, 32, '=Sheet1!$1:$2');
  //You could also use: Range := TXlsNamedRange.Create(RangeName, 1, 1, 1, 1, 2, TFlxConsts.Max_Columns + 1, 32);
  xls.SetNamedRange(Range);
3
Hi Adrian,
OMG! APIMate is a Great tool!! Thank you for your extensive answer. 
With kind regards,
TARO