Search found 169 matches: workbooks

Return to advanced search

Re: Fivewin and ADO

... OLE for better clarity. GetExcelRange() function simplifies the programmers work by including long code of 1. Open Excel OLE object 2. oExcel:WorkBooks:Add( cBook ), if the cBook is not already open on the computer or if already used, uses the workbook object that is already open. 3. Obtains ...
by nageswaragunupudi
Fri Jun 09, 2023 8:49 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Fivewin and ADO
Replies: 36
Views: 3376

Error toleauto

... endif oExcel := TOleAuto():New( "Excel.Application" ) oExcel:Visible := .T. // Muestra en pantalla la planilla Excel oBook := oExcel:Workbooks:Open( cFile ) oHoja := oExcel:Get( "ActiveSheet" ) nTotRowCount := oHoja:UsedRange:Rows:Count() * y me da el error: Error description: ...
by pedroluis
Sun Feb 05, 2023 2:40 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Error toleauto
Replies: 2
Views: 289

Re: Insertar Hoja en libro Excel

No no he probado, pero supongo que antes del oExcel:sheets:Add() debes posicionarte en la última hoja, algo así: nultima := oExcel:Workbooks:Sheets:Count() oExcel:Sheets:Item(nultima):Select() oExcel:sheets:Add() o también puedes después del oExcel:sheets:Add() moverla a la ultima posición: ...
by Sebastián Almirón
Thu Mar 31, 2022 8:50 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Insertar Hoja en libro Excel
Replies: 2
Views: 195

Insertar Hoja en libro Excel

... "Excel no está instalado", "Informe" ) RETURN(.F.) Endif oExcel := TOleAuto():New("Excel.Application") oExcel:WorkBooks:Add() oExcel:sheets("Hoja3"):Select() oHoja:=oExcel:ActiveSheet() oExcel:sheets:Add() Saludos Juan Jose
by juanjogascem
Thu Mar 31, 2022 6:45 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Insertar Hoja en libro Excel
Replies: 2
Views: 195

Re: Errores OLE en TEXCELSCRIPT

deberias cambiarlo por:

local oExcel := CreateObject( "excel.application" )
local oBook := oExcel:Workbooks:Add()
local oSheet := oBook:Worksheets( 1 )

Saludos
by jbrita
Fri Feb 25, 2022 3:50 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Errores OLE en TEXCELSCRIPT
Replies: 9
Views: 1141

Re: Create Excel Workbooks in Mod_Harbour

Hi Antonio, Sheet1 Error: Argument erroroperation: SAVE[ 1] = C c:/temp/Export_Excel.xlsx[ 2] = N 51called from: WIN_OLEAUTO:SAVE, line: 0called from: pcode.hrb, MAIN, line: 64called from: HB_HRBDO, line: 0called from: ..\source\exec.prg, EXECUTE, line: 70Source:0062:0063:0064 =>o...
by Massimo Linossi
Wed Jul 14, 2021 5:08 pm
 
Forum: mod_harbour
Topic: Create Excel Workbooks in Mod_Harbour
Replies: 8
Views: 791

Re: Create Excel Workbooks in Mod_Harbour

Dear Byron,

byron.hopp wrote:All,

What is, or is there a difference between:

Win_OleCreateObject

and

CreateObject

functions...

Byron,


Win_OleCreateObject is provided by Harbour's contrib hbwin.lib

CreateObject() is provided by FWH
by Antonio Linares
Wed Jul 14, 2021 2:15 pm
 
Forum: mod_harbour
Topic: Create Excel Workbooks in Mod_Harbour
Replies: 8
Views: 791

Re: Create Excel Workbooks in Mod_Harbour

Dear Massimo, Hello Antonio, can this command work with FastCgi too ? And what are the methods and classes that can be called ? Thanks a lot Yes, it should, as that function is provided from Harbour's hbwin.lib and it is linked inside mod_harbour DATAs and Methods of OLE objects are different for ea...
by Antonio Linares
Wed Jul 14, 2021 2:13 pm
 
Forum: mod_harbour
Topic: Create Excel Workbooks in Mod_Harbour
Replies: 8
Views: 791

Re: Create Excel Workbooks in Mod_Harbour

All,

What is, or is there a difference between:

Win_OleCreateObject

and

CreateObject

functions...

Byron,
by byron.hopp
Tue Jul 13, 2021 7:38 pm
 
Forum: mod_harbour
Topic: Create Excel Workbooks in Mod_Harbour
Replies: 8
Views: 791

Re: Create Excel Workbooks in Mod_Harbour

Hello Antonio,
can this command work with FastCgi too ?
And what are the methods and classes that can be called ?
Thanks a lot
by Massimo Linossi
Tue Jul 13, 2021 7:29 pm
 
Forum: mod_harbour
Topic: Create Excel Workbooks in Mod_Harbour
Replies: 8
Views: 791

Re: Create Excel Workbooks in Mod_Harbour

Sweet.

Thank you,
by byron.hopp
Tue Jul 13, 2021 6:51 am
 
Forum: mod_harbour
Topic: Create Excel Workbooks in Mod_Harbour
Replies: 8
Views: 791

Re: Create Excel Workbooks in Mod_Harbour

Byron,

This works fine with IIS + mod_harbour

Code: Select all  Expand view
function Main()

   local oExcel := win_OleCreateObject( "Excel.Application" )

   ? oExcel:ClassName()

return nil
by Antonio Linares
Tue Jul 13, 2021 6:33 am
 
Forum: mod_harbour
Topic: Create Excel Workbooks in Mod_Harbour
Replies: 8
Views: 791

Create Excel Workbooks in Mod_Harbour

Is it possible to access Excel via OLE on Mod_Harbour running on IIS. Any example programs?

Thanks,

Byron ...
by byron.hopp
Mon Jul 12, 2021 9:34 pm
 
Forum: mod_harbour
Topic: Create Excel Workbooks in Mod_Harbour
Replies: 8
Views: 791

Error en excel

... pero al grabar marca error cFile:="Prueba.xls" objExcel = TOleAuto():New("Excel.Application") objExcel:Visible := .T. objExcel:Workbooks:Add() objExcel:Sheets("Hoja1") oHoja:=objExcel:ActiveSheet() oHoja:Shapes:AddPicture("C:\Prueba\logo.jpg",.t.,.t.,10,5,88,80) ...
by servicomver
Thu Mar 18, 2021 6:39 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Error en excel
Replies: 0
Views: 331
Next

Return to advanced search