| Developer's reference |
|
| Reference > n_dwr_service_excel > of_save_dw2sheet |
of_save_dw2sheet() method
Converts datawindow to new Sheet of Workbook.
Syntax
| of_save_dw2sheet (datawindow, parm) |
Parameters
| datawindow | A reference to the datawindow object |
| parm | A reference to the n_dwr_service_parm object which contain a set of parameters for process of converting |
Return value
Integer. Returns 1 if it succeeds and -1 if an error occurs. If argument value is NULL, of_save_dw2sheet returns NULL.
Examples
n_dwr_service_parm lnvo_parm
n_dwr_service_excel lnvo_excel
lnvo_excel = create n_dwr_service_excel
lnvo_parm = create n_dwr_service_parm
lnvo_parm.ib_show_progress = true
lnvo_parm.is_version = '97'
lnvo_parm.ib_group_header = true
//Create Workbook
if lnvo_excel.of_create_wb('C:\MY_BOOK.XLS', lnvo_parm) = 1 then
//Converting Datawindow to Sheet "Example 1"
lnvo_parm.is_sheet_name = 'Example 1'
lnvo_excel.of_save_dw2sheet(dw_1, lnvo_parm)
//Converting Datawindow to Sheet "Example 2"
lnvo_parm.is_sheet_name = 'Example 2'
lnvo_excel.of_save_dw2sheet(dw_2, lnvo_parm)
//Converting Datawindow to Sheet "Example 3"
lnvo_parm.ib_group_header = false
lnvo_parm.is_sheet_name = 'Example 3'
lnvo_excel.of_save_dw2sheet(dw_3, lnvo_parm)
//Close Workbook
lnvo_excel.of_close_wb()
end if
| © 2003-2012 Desta, Ltd. All rights reserved. | SupportDesk |