Hello,
Can someone provide the correct to set the following?
1) Freeze pane
2) Set Header
3) Set Footer
Thank you,
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Excel Help
For freeze panel...using TExcelScript:
Carlos Sincuir
/*
* TExcelScript():FreezePanel()
*/
METHOD FreezePanel( cRange ) CLASS TExcelScript
::oExcel:Range( cRange ):Select()
::oExcel:Application:ActiveWindow:FreezePanes := .T.
RETURN SelfHello,
I am using the following code and getting an error.
oAs := oExcel:ActiveSheet()
oAs:FreezePanes := .T.
Any ideas?
Thank you,
cdmmaui,
as Carlos pointed out, you have do do a "select" before.
The freeze command works like in real Excel.
First you have to select a cell and then you can freeze the sheet.
This sample works for me:
Regards,
Detlef
as Carlos pointed out, you have do do a "select" before.
The freeze command works like in real Excel.
First you have to select a cell and then you can freeze the sheet.
This sample works for me:
oWin := oExcel:Get( "ActiveWindow" )
oSheet:Cells( 2, 1 ):Select()
oWin:Set( "FreezePanes", .t. )Regards,
Detlef
Danke, Detlef. Es hat funktioniert.
Saludos
Un saludo
Manuel
Manuel