EXCEL例程2
来源:互联网 发布:英语六级网络课程 编辑:程序博客网 时间:2024/05/06 05:47
REPORT ZEXCEL_ZLT.
TYPE-POOLS OLE2 .
****定义OLE对象****
DATA: APPLICATION TYPE OLE2_OBJECT, "定义EXCEL对象
WORKBOOK TYPE OLE2_OBJECT, "定义工作区对象
WORKSHEET TYPE OLE2_OBJECT. "定义具体的SHEET对象
DATA CELL TYPE OLE2_OBJECT. "定义CELL对象
****存储每个CELL值得变量****
DATA: VAL1(30) TYPE C.
****每个CELL的位置****
DATA: R1 TYPE I,
R2 TYPE I.
****创建EXCEL对象*****
CREATE OBJECT APPLICATION 'Excel.Application'.
****创建工作区对象*****
CALL METHOD OF APPLICATION 'Workbooks' = WORKBOOK.
*******************以下是新增一个SHEET操作********************
SET PROPERTY OF APPLICATION 'SheetsInNewWorkbook' = 1.
CALL METHOD OF WORKBOOK 'ADD' = WORKSHEET.
CALL METHOD OF WORKSHEET 'ACTIVATE'.
****向EXCEL中写入数据****
R1 = 1.
R2 = 2.
VAL1 = 'CON'.
CALL METHOD OF APPLICATION 'CELLS' = CELL
EXPORTING
#1 = R1
#2 = R2.
SET PROPERTY OF CELL 'VALUE' = VAL1.
****保存文件****
CALL METHOD OF worksheet 'SAVEAS'
EXPORTING #1 = 'C:/file.xls'
#2 = 1.
****关闭WORKSHEET****
CALL METHOD OF WORKSHEET 'CLOSE'.
****关闭WORKBOOK****
CALL METHOD OF WORKBOOK 'CLOSE'.
****关闭EXCEL对象****
CALL METHOD OF APPLICATION 'QUIT'.
****释放对象****
FREE OBJECT CELL.
FREE OBJECT WORKSHEET.
FREE OBJECT WORKBOOK.
FREE OBJECT APPLICATION.
TYPE-POOLS OLE2 .
****定义OLE对象****
DATA: APPLICATION TYPE OLE2_OBJECT, "定义EXCEL对象
WORKBOOK TYPE OLE2_OBJECT, "定义工作区对象
WORKSHEET TYPE OLE2_OBJECT. "定义具体的SHEET对象
DATA CELL TYPE OLE2_OBJECT. "定义CELL对象
****存储每个CELL值得变量****
DATA: VAL1(30) TYPE C.
****每个CELL的位置****
DATA: R1 TYPE I,
R2 TYPE I.
****创建EXCEL对象*****
CREATE OBJECT APPLICATION 'Excel.Application'.
****创建工作区对象*****
CALL METHOD OF APPLICATION 'Workbooks' = WORKBOOK.
*******************以下是新增一个SHEET操作********************
SET PROPERTY OF APPLICATION 'SheetsInNewWorkbook' = 1.
CALL METHOD OF WORKBOOK 'ADD' = WORKSHEET.
CALL METHOD OF WORKSHEET 'ACTIVATE'.
****向EXCEL中写入数据****
R1 = 1.
R2 = 2.
VAL1 = 'CON'.
CALL METHOD OF APPLICATION 'CELLS' = CELL
EXPORTING
#1 = R1
#2 = R2.
SET PROPERTY OF CELL 'VALUE' = VAL1.
****保存文件****
CALL METHOD OF worksheet 'SAVEAS'
EXPORTING #1 = 'C:/file.xls'
#2 = 1.
****关闭WORKSHEET****
CALL METHOD OF WORKSHEET 'CLOSE'.
****关闭WORKBOOK****
CALL METHOD OF WORKBOOK 'CLOSE'.
****关闭EXCEL对象****
CALL METHOD OF APPLICATION 'QUIT'.
****释放对象****
FREE OBJECT CELL.
FREE OBJECT WORKSHEET.
FREE OBJECT WORKBOOK.
FREE OBJECT APPLICATION.
- EXCEL例程2
- EXCEL例程
- EXCEL例程1
- EXCEL例程3
- Excel多工作簿例程
- QT入门例程【2】
- CC2640 SimpleBLEPeripheral例程-2
- CC2640例程2
- 例程
- C#中访问Excel(xls)数据源的例程
- 使用VB或VC操作Excel 2003(例程)
- (转)使用VC操作Excel 2003(例程)
- 【VBA研究】用SQL语句读取EXCEL数据例程
- 找不到 Microsoft Excel Driver ODBC 驱动程序的安装例程 解决方案
- 驱动学习(2)-DriverEntry例程
- C++初学之例程2
- OpenCL例程2-数组相加
- 1.3.2 线程附属例程
- 百练---求和---2940
- spring的xml文件中各种乱七八糟的声明
- 疑问:为什么要使用href=”javascript:void(0);”?
- 百练---数组逆序重放---2687
- EXCEL例程1
- EXCEL例程2
- kettle教程
- php报warning:Creating default object from empty value解决
- EXCEL例程3
- 空心三角形
- 百练---整数的立方和----2679
- 符号表与哈希表
- 关于VC操作Excel(解决mircoSoft jet 数据库引擎找不到对象)
- 网络服务器初探