Create Excel Workbooks in Mod_Harbour

[byron.hopp]

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

Thanks,

Byron ...

[Antonio Linares]

Byron,

This works fine with IIS + mod_harbour

Code: Select all | Expand

function Main()

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

   ? oExcel:ClassName()

return nil

[byron.hopp]

Sweet.

Thank you,

[Massimo Linossi]

Hello Antonio,
can this command work with FastCgi too ?
And what are the methods and classes that can be called ?
Thanks a lot

[byron.hopp]

All,

What is, or is there a difference between:

Win_OleCreateObject

and

CreateObject

functions...

Byron,

[Antonio Linares]

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 each used OLE object (that belongs to a different OLE class)

In these forums you find many examples for using Excel

[Antonio Linares]

Dear Byron,

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

[Massimo Linossi]

Hi Antonio,

Code: Select all | Expand

Sheet1 Error: Argument error
operation: SAVE
[ 1] = C c:/temp/Export_Excel.xlsx
[ 2] = N 51
called from: WIN_OLEAUTO:SAVE, line: 0
called from: pcode.hrb, MAIN, line: 64
called from: HB_HRBDO, line: 0
called from: ..\source\exec.prg, EXECUTE, line: 70

Source:
0062:
0063:
0064 =>oWorkBook:Save(nomefile, 51)
0065: oWorkBook:Close(.T.)
0066: oExcel:Quit()
 

What is the correct sintax for saving a file in Excel ?

[Antonio Linares]

Please try it this way:

viewtopic.php?p=234184&sid=1625ddf16f49d5d68573932f6ae49194#p234184