[转帖]ABAP实践学习--ABAP中将SAP数据按格式保存到EXCEL(OLE)

最新推荐文章于 2024-04-16 10:26:01 发布

原创

最新推荐文章于 2024-04-16 10:26:01 发布 · 2.9k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#excel #sap #object #constants #parameters #border

这是一个示例ABAP程序，演示如何使用OLE2接口调用Microsoft Excel，将R/3系统的内部表数据导出到Excel文件中。程序通过创建Excel对象、设置属性和调用方法来实现数据传输，并确保Excel在后台运行。用户需要提供Excel文件路径，程序会将数据保存到指定文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

REPORT ZZBGS700 MESSAGE-ID Z1.
*----------------------------------------------------------------------*
* Topic:       Example: Calling up Microsoft Excel.                    *
*                                                                      *
* Description: Example program that is calling up EXCEL, transfer      *
*              an internal table and returning to R/3.                 *
*                                                                      *
* Implementing The program uses OLE.                                   *
* In R/3 release 3.0x, the command set of ABAP/4 ontepreter has been   *
* increased with keywords that allow access to external objects through*
* OLE2. In SAP the new keywords for OLE2 are:                          *
*                                                                      *
* 1. Create Object                                                     *
* 2. Set Property                                                      *
* 3. Get Property                                                      *
* 4. Call Method                                                       *
* 5. Free Object                                                       *
*                                                                      *
*                                                                      *
* Authoriz.    None.                                                   *
*                                                                      *
* Submitting: Run by SA38, SE38.                                      *
*                                                                      *
* Parametre:   Excel file path and filename.                           *
*                                                                      *
* Output:      Excel file with data.                                   *
*                                                                      *
* Customizing: Check that EXCEL is registered in R/3 via transaction   *
*              SOLE.                                                   *
*   &nbs

最低0.47元/天解锁文章

200万优质内容无限畅学