How to EMBED Excel objects

Excel | object
In the program development, sometimes need to PowerBuilder and Excel application used in combination with, if the data retrieval came out, in accordance with the format, data transfer to Excel in the form. Implementation steps are as follows:



1. Create and the connection object:

Oleobject loo_excel

Oleobject loo_sheet

Loo_excel = create oleobject

Loo_excel.ConnectToNewObject ("Excel. Application ")



// Set the default font and size

Loo_excel.Application.StandardFont = "Arial Narrow"

Loo_excel.Application.StandardFontSize = "8"

Loo_excel.Application.Workbooks.Add ()

Loo_sheet = loo_excel.Application.Workbooks (1). worksheets (1)

Loo_excel.Application.Visible = true

Loo_excel.Application.ScreenUpdating = false/shield visible property

2. Calls Excel itself the attributes of the function, through data window complete data to Excel:

Loo_excel.Application.ScreenUpdating = true // set visible property

3. Disconnect and release the object: loo_excel.DisconnectObject ()

/Note: Suggested reference API function to capture the Handle.

Destroy loo_excel