ENVIRONMENT DIVISION.
INPUT-OUTPUT SECTION.
FILE-CONTROL.
SELECT LEXCEL
ASSIGN TO "d:\VET-SIS\BARRAS.XLS"
ORGANIZATION IS LINE SEQUENTIAL.
DATA DIVISION.
FILE SECTION.
FD LEXCEL
LABEL RECORD IS STANDARD.
01 REC-LEXCEL PIC X(500).
WORKING-STORAGE SECTION.
01 EXCEL OBJECT REFERENCE COM IS GLOBAL.
01 WORKBOOK OBJECT REFERENCE COM IS GLOBAL.
01 COM-TRUE PIC 1(1) BIT VALUE B"1" IS GLOBAL.
01 APPLICATION PIC X(20) VALUE "EXCEL.APPLICATION" IS GLOBAL.
01 EXCEL_FILE PIC X(35) VALUE "d:\VET-SIS\BARRAS.XLS".
01 L-1.
02 PIC X(6) VALUE "<BODY>".
02 PIC X(15) VALUE "<TR><TH> ".
01 L-2.
02 PIC X(7) VALUE "<TABLE>".
01 L-3.
02 PIC X(10) VALUE "<TR><TH> ".
02 NOM-I PIC X(85).
02 PIC X(4) VALUE "<TD>".
02 COD-I PIC X(6) VALUE "000000".
02 PIC X(4) VALUE "<TD>".
02 PRECIO-I pic ZZZ,ZZ.99.
01 GRUPO.
02 G1 PIC 999.
02 G2 PIC X(17).
01 COD pic X(6) VALUE "000000".
01 RUTA PIC X(256).
01 REDD GLOBAL EXTERNAL.
02 RED PIC X(256).
01 RUTA-ETI PIC X(256) VALUE "C:\Program Files (x86)\Zebra Technologies\ZebraDesigner Pro 2\bin\Design.exe".
PROCEDURE DIVISION.
INICIO.
OPEN OUTPUT LEXCEL CLOSE LEXCEL.
OPEN EXTEND LEXCEL.
MOVE POW-FALSE TO ENABLED OF CTPUSH3.
GRAVAEXCEL.
WRITE REC-LEXCEL FROM L-1.
WRITE REC-LEXCEL FROM L-2.
INICIO.
MOVE SPACES TO RUTA.
STRING RED DELIMITED BY SPACES
"Artic.DAT" DELIMITED BY SIZE
INTO RUTA.
MOVE RUTA TO WF-ARTIC.
OPEN INPUT ARTIC.
MOVE " " TO DESCRIPCION-AR.
START ARTIC KEY NOT < DESCRIPCION-AR INVALID KEY
GO LEE.
LEE. READ ARTIC NEXT AT END GO FIN.
MOVE GRUPO-AR TO GRUPO.
IF G1 = 002 GO LEE.
IF G1 = 007 GO LEE.
IF G1 = 008 GO LEE.
MOVE CODIGO-AR TO COD.
INSPECT COD REPLACING ALL " " BY "0".
move COD to COD-I.
MOVE DESCRIPCION-AR TO NOM-I.
MOVE PRECIO-AR TO PRECIO-I.
WRITE REC-LEXCEL FROM L-3.
GO LEE.
FIN.
CLOSE ARTIC.
CLOSE LEXCEL.
INVOKE COM "CREATE-OBJECT" USING APPLICATION RETURNING EXCEL.
* INVOKE EXCEL "SET-VISIBLE" USING COM-TRUE.
INVOKE EXCEL "GET-WORKBOOKS" RETURNING WORKBOOK.
INVOKE WORKBOOK "Open" using EXCEL_FILE.
invoke pow-self "THRUEVENTS".
INVOKE POW-SELF "executesync" USING RUTA-ETI.
INVOKE EXCEL "QUIT".
EXIT PROGRAM.
Marcadores