PowerBuilder中数据窗口与Excel通信技术的实现.PDF

33 6 V o l. 33, l . 6 2006 6 A pp lied Science and T echno logy June 2006 : 1009- 671X ( 2006 06- 0093- 03 Pow erBu ilder Excel 谢 红, 李龙文 ( 哈尔滨工程大学 信息与通信工程学院, 黑龙江 哈尔滨 150001 : Pow erBuilder OLE , Excel, ( Excel, Ex ce l, P ow erBuilder Ex cel . , . : ; OLE; Pow erBu ilde r : T P311. 11 : A Realization of communication technology between dataw indow in PowerBuilder and Excel X IE H ong, L I Long-w en ( Schoo l o f Inform ation and Communication Eng ineer ing, H arb in Eng ineer ing U n ive rsity, H arbin 15001, China A bstrac t: Th is paper introduces the m eans o f transm itting the data of dataw indow into Excel by OLE techno logy in P ow erBu ilder. T he data( including the tex t con tro l, the p icture contro l of each a rea in da taw indow a re transm itted into Ex ce l, and m anipulated dynam i- ca lly in Ex cel. It o ffe rs a new m ethod o f comm un ication betw een Pow erBuilder and Excel. T he deta iled exp lana tions o f the actua l oper- a tion are dem onstrated and the prog ram codes a re g iven w h ich have passed debugg ing. K eyw ords: dataw indow; OLE; Pow erBuilder ( o ffice autom a tion, OA , . , ( . Pow er- Ex ce,l Exce l Builder, Pow erBuilder , Ex cel. , Pow erBuilder 1 OLE 概述 , . , OLE( W indow s . . , , OLE , , [ 1] . Pow erBu ilder OLE , . Exce l, , OLE , Excel