PB导出数据excel格式dw2xls

你是否正在寻找关于dw2xls的内容？让我把最实用的东西奉献给你：

PB导出数据excel式dw2xls

使用dw2xls控件

语法

uf_save_dw_as_excel ( dw, filename )

参数

dw A reference to the datawindow object
filename A string whose value is the name of the file you want to create. If filename is not on the operating system's search path, you must enter the fully qualified name.

返回

Integer. Returns 1 if it succeeds and -1 if an error occurs.

举例

integer li_ret li_ret = uf_save_dw_as_excel(dw_1, 'c:\doc\report.xls') if li_ret = 1 then //success //... else //fail //... end if

我的实际例子

首先 migrate dw2xls

界面

相关代码

导出结果

还有相关的就是

uf_save_dw_as_excel_parm() function

Converts datawindow into excel file. Allows to specify some options for process of converting.

语法

uf_save_dw_as_excel_parm ( dw, filename, parm )

参数

dw A reference to the datawindow object
filename A string whose value is the name of the file you want to create. If filename is not on the operating system's search path, you must enter the fully qualified name
parm A reference to the n_dwr_service_parm object which contain a set of parameters for process of converting

返回

Integer. Returns 1 if it succeeds and -1 if an error occurs.

举例

//export using parameters integer li_ret n_dwr_service_parm lnvo_parm lnvo_parm = create n_dwr_service_parm lnvo_parm.ib_header = false //skip header band 没有标题行 lnvo_parm.ib_summary = false //skip summary band lnvo_parm.ib_footer = false //skip footer band lnvo_parm.ib_group_header = false //skip all group headers lnvo_parm.ib_group_trailer = false //skip all group trailers li_ret = uf_save_dw_as_excel_parm(dw_1, 'c:\doc\report.xls', lnvo_parm) if li_ret = 1 then //success //... else //fail //... end if

下面这个没有测试成功，可能版本不对
is_header_text 没有这个方法

// adding a header to generated XLS integer li_ret n_dwr_service_parm lnvo_parm lnvo_parm = create n_dwr_service_parm lnvo_parm.is_header_text = "Report" lnvo_parm.ib_header_font_underline = True li_ret = uf_save_dw_as_excel_parm(dw_1, 'c:\doc\report.xls', lnvo_parm) if li_ret = 1 then //success //... else //fail //... end if

以上就是关于dw2xls的全部内容，相信你一定会非常满意，。

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/shenmilingyu/article-3585-1.html