FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour Inmovilizar filas en excel
Posts: 400
Joined: Fri May 11, 2007 08:20 PM

Inmovilizar filas en excel

Posted: Wed Dec 15, 2021 04:31 AM

Gente necesito inmovilizar filas en excel
Gracias

fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql
Posts: 143
Joined: Fri Oct 07, 2005 03:14 PM

Re: Inmovilizar filas en excel

Posted: Mon Jan 03, 2022 08:53 PM

if (oExcel:=ExcelObj())== nil
mensaje('Excel no esta instalado!!')
endif

oExcel:ScreenUpdating := .f.
oExcel:Application:DisplayAlerts:=.f.
..
..
..

// Congelamos encabezado
oWin := oExcel:ActiveWindow
oWin:SplitRow := 7
oWin:FreezePanes := .t.

Saludos
Joel Andujo

Posts: 8523
Joined: Tue Dec 20, 2005 07:36 PM

Re: Inmovilizar filas en excel

Posted: Mon Jan 03, 2022 11:17 PM
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341

Continue the discussion