Print heading on each page in ole2

[avarghese03]

Hi,

I need to make an excel report using forms 6i ole2 that repeats column titles on every page when it is printed. The first row is the column title.

Any ideas?

Thanks
Alex

 

[avarghese03]

Ok, I found a solution to this. Here it is for those who dont have it yet:

oPageSetup := OLE2.GET_OBJ_PROPERTY(oWorkSheet, 'PageSetup');
OLE2.SET_PROPERTY (oPageSetup, 'PrintTitleRows', '$1:$1');