| Developer's reference |
|
| Reference > n_dwr_service_excel > of_save_ds2sheet |
of_save_ds2sheet() method
Converts datastore to new Sheet of Workbook.
Syntax
| of_save_ds2sheet (datastore, parm) |
Parameters
| datastore | A reference to the datastore 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_ds2sheet 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 Datastore to Sheet "Example 2"
lnvo_parm.is_sheet_name = 'Example 2'
lnvo_excel.of_save_ds2sheet(ds_1, lnvo_parm)
//Close Workbook
lnvo_excel.of_close_wb()
end if
| © 2003-2012 Desta, Ltd. All rights reserved. | SupportDesk |