Search found 20 matches: oworkbook

Return to advanced search

Re: De Excel a MySql

Code: Select all  Expand view
oRange:Parent:Parent:Close( .f. )


oRange:Parent --> oSheet
oRange:Worksheet --> oSheet
oSheet:Parent --> oWorkBook
by nageswaragunupudi
Wed Jul 19, 2023 3:49 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: De Excel a MySql
Replies: 7
Views: 253

Re: TOleAuto() No cierra el proceso EXCEL.EXE

holoa Esteban.

A mi me pasaba lo mismo y ahura cierro asi:

oHoja:=NIL
oWorkBook:SaveAs(fichsali)
oExcel:Quit()
oExcel:=NIL

Y cierra el proceso EXCEL.EXE

Un saludo

Carlos
by colthop
Wed Feb 15, 2012 6:19 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: TOleAuto() No cierra el proceso EXCEL.EXE
Replies: 2
Views: 569

Añadir series y fondos con excel (Toleauto)

... de relleno. ¿Alguien me puede facilitar un ejemplo? Esto es lo que estoy generando: oExcel := TOleAuto():New("Excel.Application") oWorkBook := oExcel:WorkBooks:Add() oExcel:Visible := .t. oHoja := oExcel:ActiveSheet() oHoja:Name:= "Datos" oHoja:Range("B1:B"+ALLTRIM(STR(n))):select() ...
by sergisenna
Mon Nov 14, 2011 12:28 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Añadir series y fondos con excel (Toleauto)
Replies: 1
Views: 575

Re: Abrir mas de una Hoja de Excel

Willy,

Gracias por el detalle. No estaba utilizando el objeto oWorkBook.

Lo pruebo y te aviso.

Abazos,
by jllinas
Wed Aug 17, 2011 2:56 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Abrir mas de una Hoja de Excel
Replies: 4
Views: 793

Error Excel

... gracias desde ya. //*********** //aca creo el excel Function creatabla(cTabla, Xlistad, xlistah) local aEstructura local nveces, N, oExcel, oWorkBook, xatt, oSheet oExcel := CREATEOBJECT( "Excel.Application" ) OEXCEL:DISPLAYALERTS=.F. oWorkBook := oExcel:WorkBooks:Add() oSheet ...
by diegopolverelli
Wed Jun 15, 2011 6:03 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Error Excel
Replies: 0
Views: 1254

Re: ¿¿¿Generar reporte de 100+ páginas en Excel en 4 segundos???

... DEFAULT lInfo:=.T. BYNAME cPathDll, lInfo IF !::LoadDll() return Self ENDIF cXlsFile:=cFullFileName(cXlsFile) BYNAME cXlsFile ::oWorkBook := ::oXlsFile:XLSFile:Workbook ::nDateFormat:=::oWorkbook:FormatStrings:AddFormat(::cDateFormat) ::oWorkbook:Sheets(1):Name := "Hoja1" ...
by César E. Lozada
Sat May 08, 2010 5:13 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: ¿¿¿Generar reporte de 100+ páginas en Excel en 4 segundos???
Replies: 4
Views: 1078

Re: No exported method: SAVEAS

Diego,

Parece que en vez de haber un objeto ahí, hay un array. Prueba esto:

oWorkBook := oExcel:WorkBooks:Add()
MsgInfo( ValType( oWorkBook ) )
by Antonio Linares
Thu May 06, 2010 9:25 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: No exported method: SAVEAS
Replies: 6
Views: 1134

No exported method: SAVEAS

... en ese lugar me da error): oExcel := CREATEOBJECT( "Excel.Application" ) //oExcel:WorkBooks:Open( xruta ) OEXCEL:DISPLAYALERTS=.F. oWorkBook := oExcel:WorkBooks:Add() oSheet := oExcel:ActiveSheet // **************** DO CASE CASE XORDEN=1 oSheet:Cells( 1, 1 ):Value = "Codigo" ...
by diegopolverelli
Thu May 06, 2010 8:53 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: No exported method: SAVEAS
Replies: 6
Views: 1134

Fallo Excel

... en ese lugar me da error): oExcel := CREATEOBJECT( "Excel.Application" ) //oExcel:WorkBooks:Open( xruta ) OEXCEL:DISPLAYALERTS=.F. oWorkBook := oExcel:WorkBooks:Add() oSheet := oExcel:ActiveSheet // **************** DO CASE CASE XORDEN=1 oSheet:Cells( 1, 1 ):Value = "Codigo" ...
by diegopolverelli
Thu May 06, 2010 12:47 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Fallo Excel
Replies: 0
Views: 371

Re: How to end oExcel := TOleAuto():New( "Excel.Application" ) ?

... "you will not find EXCEL.EXE in the Task Manager, Processes List")   RETURN NIL Tested using Office 2007. It is also better to do a oWorkBook:Close() before the oExcel:Quit() oWorkBook:=oExcel:WorkBooks:Open(ALLTRIM(cfile))oWorkBook:Close()oExcel:Quit()  ...
by anserkk
Sat Apr 24, 2010 6:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: How to end oExcel := TOleAuto():New( "Excel.Application" ) ?
Replies: 3
Views: 895

Re: Working with Excel

... I don't know if it is possible, to run it after : TOleAuto():New( "Excel.Application" ) What is included : Editor for : oWin, oExcel, oWorkbook and oSheet. Includes a Syntax-Field and a Memo-Field. A Painter, to define Fonts, Colors and some more Settings. Writing the Source, or start ...
by ukoenig
Fri Mar 19, 2010 12:52 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Working with Excel
Replies: 21
Views: 7713

Re: oExcel:Quit() sin grabar (ToleAuto)

::oWorkBook:SaveAs(cFileXls)


::oExcel:Visible = .T.

// ::oExcel:Quit()

::Excel := Nil

saludos.
by sysctrl2
Mon Jan 11, 2010 7:46 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: oExcel:Quit() sin grabar (ToleAuto)
Replies: 3
Views: 546

Excel : opening existing xls-file

Hello, Till now i can use a excel aplication as : oExcel := CreateObject( "Excel.Application" ) oWorkBook := oExcel:WorkBooks:Add() ........ Ok , this works , excel seems to generate a file (name) , map1.xls , .... Now , i try to open a existing xls file without succes ...
by Demont.frank
Tue Apr 14, 2009 12:35 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Excel : opening existing xls-file
Replies: 2
Views: 647

... To save use the third parameter in the method SaveAs of WorkBook object FUNCTION MAIN() LOCAL oExcel := CREATEOBJECT( "Excel.Application" ) LOCAL oWorkbook := oExcel:Workbooks LOCAL oSheet := oExcel:ActiveSheet ... savefile := oWorkbook.SaveAs( fileXL, ,"YourPassWord" ) ... RETURN NIL
by Rochinha
Fri Oct 31, 2008 1:14 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: How to input a password into a XLS file wirh OLE
Replies: 7
Views: 1225

Create a Excel-Sheet of any DBF-File with AutoOle (Update)

... ][ 1 ], ; aFieldname[ n ][ 2 ], ; aFieldname[ n ][ 3 ] } ) next // CLIPBOARD DEFINE CLIPBOARD oClp oExcel := TOleAuto():New( "Excel.Application" ) oWorkBook := oExcel:WorkBooks:Add() nSheets := oExcel:Sheets:Count() for n := 1 to nSheets - 1 oExcel:Worksheets( n ):Delete() next oExcel:Set( "DisplayAlerts", ...
by ukoenig
Mon Feb 04, 2008 7:27 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Create a Excel-Sheet of any DBF-File with AutoOle (Update)
Replies: 4
Views: 1611
Next

Return to advanced search