泰宁新闻网

PB导出数据excel格式dw2xls

鞋

泰宁新闻网 http://www.tainingxinwen.cn 2020-04-08 10:21 出处:网络
dw2xls,PB导出数据excel格式dw2xls PB导出数据excel格式dw2xls  使用DW2XLS控件 语法 uf_save_dw_as_excel ( dw, filename ) 

dw2xls,PB导出数据excel格式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

 

PB导出数据excel格式dw2xls

界面

PB导出数据excel格式dw2xls

相关代码

PB导出数据excel格式dw2xls

导出结果

PB导出数据excel格式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


 

PB导出数据excel格式dw2xls的相关内容如下:

dw2xls的相关网页热门搜索词

怎样导出excel表格|excel导入数据格式不对|excel表格怎么导出图片格式|excel怎么保存pdf格式|导出的excel表格不能求和|excel格式全部消失了|excel怎样转换pdf格式|sap导出excel格式设置|excel怎么转换dat格式|

本文标题:PB导出数据excel格式dw2xls
http://www.tainingxinwen.cn/qitaxinxi/344566.html

0

精彩评论

暂无评论...
验证码 换一张
取 消