FiveTech Software tech support forums

... datetime values with fraction of seconds. Also increased column size to fit the contents. * FWMariaRowSet: - Method ToExcel(): (1) Enclosed :FreezePanes in TRY/CATCH block to avoid runtime errors in some installtions. (2) Date and DateTime values are exported as character data when the Year ...

In the next version to be released.

1. :lFreezePanes does not raise runtime error.
2. Dates and TimeStamps earlier than the year 1900 are exported as text to avoid loss of data and export errors.

It appears you are using

Code: Select all  Expand view

oRowSet:ToExcel()

of FWMaria lib.
We will now include this code in TRY/CATCH block for future.

But we advise you to use oBrw:ToExcel() which is safer.

https://fivetechsupport.com/forums/viewtopic.php?f=3&t=3950

Regards, saludos.

Estimado Foro Al realizar la exportacion a Excel desde un browse me muestra el siguiente error desde algunas consultas Error description: Error Excel.Application:ACTIVEWINDOW/3 DISP_E_MEMBERNOTFOUND: _FREEZEPANES Args: [ 1] = L .T. Stack Calls =========== Called from: => TOLEAUTO:_FREEZEPANES( 0 ...

Hi, My app run on 15 pcs but I get error only on 2 pcs when I call function oBrw:ToExcel() I get this error: Application =========== Path and name: myexe.exe (32 bits) Size: 7,345,664 bytes Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20161218) FiveWin version: FWHX 17.09 C compiler versi...

Thanks friend

FWH1804

9335 oWin:FreezePanes := .t. //I put it as a comment it passes

9241 oSheet:Paste() //This is the problem

Buenas tardes Estimados Con Office 2021 me sale el siguiente error: No se puede asignar la propiedad FreezePanes de la clase Window. (0x800A03EC): Microsoft Excel TXBROWSE:TOEXCEL( 9335 ) Con Office 2019 me sale el siguiente error: No se puede obtener la propiedad Paste de ...

Buenas tardes Estimados Con Office 2021 me sale el siguiente error: No se puede asignar la propiedad FreezePanes de la clase Window. (0x800A03EC): Microsoft Excel TXBROWSE:TOEXCEL( 9335 ) Con Office 2019 me sale el siguiente error: No se puede obtener la propiedad Paste de ...

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

nageswaragunupudi wrote:May we know the Excel version of your customer?
The code works well from version 2003 onwards.

From customer :
newest version Office 2013

I will try to omit the line :

oWin:FreezePanes := .t. <--- Gives error

Or , can it be changed in another line ?

Frank

... the last month's , one off mine custumers reports a error the last days in xbrowse:toexcel : oWin := oExcel:ActiveWindow oWin:SplitRow := 1 oWin:FreezePanes := .t. <--- Gives error Error description: Error Excel.Application:ACTIVEWINDOW/3 DISP_E_MEMBERNOTFOUND: _FREEZEPANES Args: [ 1] = L ...

... oSheet := oExcel:Get( "ActiveSheet" ) oWin := oExcel:Get( "ActiveWindow" ) oSheet:Name := "Show" oSheet:Cells( nDataStart, 1 ):Select() oWin:Set( "FreezePanes", .t. ) oWin:Set( "SplitColumn", 2 ) // Freeze Rows and Cols oSheet:Cells:Font:Size := 10 oSheet:Cells:Font:Name := "Arial" For i := 1 to ...

Hello,

I am using the following code and getting an error.

oAs := oExcel:ActiveSheet()

oAs:FreezePanes := .T.

Any ideas?

Thank you,