How to split a sheet.

[tilltek]

I can format an Excel sheet OK with statements like ....
oExcel.ActiveSheet.Columns[6].NumberFormat = "##,###.00;;"
And
oExcel.ActiveSheet.Columns[2].ColumnWidth = 8
And so on, but I can't for the life of me figure out how to programmatically split the sheet so that the column headings in row one remain visible while the rest of the sheet can be scrolled.
Nor can I work out how to enter a conditional format.
Normally, I manually create "striped" sheets to resemble fan fold paper by highlighting the whole spreadsheet and then going into conditional formatting and selecting "formula is" and "=MOD(ROW(),2)=1" and "light yellow", which produces sheets that are very easy on the eye.
Can I do this from VFP programmatically?

Thanks in advance
Ken F

 

[Mike Lewis]

Hi Ken,

I can't for the life of me figure out how to programmatically split the sheet so that the column headings in row one remain visible while the rest of the sheet can be scrolled.

Try something like this:

loExcel.ActiveWindow.SplitRow = 2

where 2 is the number of rows you want to keep visible.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[tilltek]

Thanks Mike.