ENVIRONMENT DIVISION.
INPUT-OUTPUT SECTION.
FILE-CONTROL.
SELECT LEXCEL
ASSIGN TO "d:\excel\zapato.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:\excel\zapato.XLS".
01 L0.
02 PIC X(45) VALUE
"<HTLM><HEAD><TITLE>ESTADISTICO</TITLE></HEAD>".
01 L-1.
02 PIC X(6) VALUE "<BODY>".
02 PIC X(15) VALUE "<TR><TH><B> ".
02 L1-CIA PIC X(60) VALUE
"ARTES STILOS DEL CALZADO SAC ".
02 PIC X(6) VALUE "<\B>".
01 L-11.
02 PIC X(15) VALUE "<TR><TH>".
02 PIC X(55) VALUE
"VENTAS POR MESES ZAPATERIA SCOTT".
01 L-30.
02 PIC X(7) VALUE "<TABLE>".
01 L-2.
02 PIC X(4) VALUE "<BR>".
02 L2-CIA PIC X(112) VALUE SPACES.
02 L3-MES PIC X(10).
02 L3-RMES REDEFINES L3-MES.
03 L3-DMES PIC BXXX.
03 L3-LET PIC XXX.
03 L3-HMES PIC XXX.
02 L3-ANO PIC Z9999.
01 L-3.
02 PIC X(4) VALUE "<BR>".
02 L3-CIA PIC X(32).
02 PIC X(7) VALUE " ".
02 L2-RFC PIC X(15) VALUE SPACES.
01 LLL.
02 PIC X(7) VALUE "<BR><U>".
02 L-0 PIC X(163) VALUE SPACES.
01 L-4.
02 PIC X(18) VALUE "<TR><TH><U> AÑOS".
02 PIC X(15) VALUE "<TH><U> ENE".
02 PIC X(15) VALUE "<TH><U> FEB".
02 PIC X(15) VALUE "<TH><U> MAR".
02 PIC X(15) VALUE "<TH><U> ABR".
02 PIC X(15) VALUE "<TH><U> MAY".
02 PIC X(15) VALUE "<TH><U> JUN".
02 PIC X(15) VALUE "<TH><U> JUL".
02 PIC X(15) VALUE "<TH><U> AGO".
02 PIC X(15) VALUE "<TH><U> SET".
02 PIC X(15) VALUE "<TH><U> OCT".
02 PIC X(15) VALUE "<TH><U> NOV".
02 PIC X(15) VALUE "<TH><U> DIC".
01 L-5.
02 PIC X(15) VALUE "<TR><TH> ".
02 L-ANO PIC Z,ZZZ.
02 PIC X(4) VALUE "<TD>".
02 L-ENE PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-FEB PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-MAR PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-ABR PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-MAY PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-JUN PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-JUL PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-AGO PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-SET PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-OCT PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-NOV PIC ZZ,ZZZ.ZZ.
02 PIC X(4) VALUE "<TD>".
02 L-DIC PIC ZZ,ZZZ.ZZ.
01 L55.
02 PIC X(24) VALUE "<TR><TD>".
02 PIC X(37) VALUE "<TD>".
02 PIC X(20) VALUE "<TD>".
02 PIC X(20) VALUE "<TD>".
02 PIC X(20) VALUE "<TD>".
02 PIC X(20) VALUE "<TD>".
01 TABLA-CRT.
02 T-CRT PIC X(80) OCCURS 25 TIMES.
01 ANO-X.
02 AA-N PIC 99.
02 BB-N PIC 99.
01 X-ANO REDEFINES ANO-X PIC 9(4).
01 TIPO PIC X.
01 CIA PIC X(15).
01 A1 PIC 99 VALUE 0.
01 Z PIC 99 VALUE 0.
01 ZZ PIC 99 VALUE 0.
01 X PIC 99 VALUE 0.
01 H PIC X.
01 V PIC X.
01 SD1 PIC X.
01 CANT-I PIC ZZZZZZZ.ZZ.
01 C2 PIC ZZ.ZZZ.
01 TIENDA PIC 99.
01 AA PIC 99.
01 BB PIC 99.
01 L PIC 999.
01 YEAR1 PIC 999.
01 CARA PIC X.
01 CADENA PIC X(8).
PROCEDURE DIVISION.
INICIO. OPEN INPUT VENTA.
OPEN OUTPUT LEXCEL CLOSE LEXCEL.
OPEN EXTEND LEXCEL.
GRAVAEXCEL.
INSPECT L-0 REPLACING CHARACTERS BY "Í".
INSPECT L0 REPLACING ALL " " BY " ".
INSPECT L-1 REPLACING ALL " " BY " ".
INSPECT L-11 REPLACING ALL " " BY " ".
INSPECT L-2 REPLACING ALL " " BY " ".
INSPECT L-3 REPLACING ALL " " BY " ".
INSPECT L-30 REPLACING ALL " " BY " ".
INSPECT L-4 REPLACING ALL " " BY " ".
WRITE REC-LEXCEL FROM L0.
WRITE REC-LEXCEL FROM L-1.
WRITE REC-LEXCEL FROM L-3.
WRITE REC-LEXCEL FROM L-11.
WRITE REC-LEXCEL FROM L-2.
WRITE REC-LEXCEL FROM L-3.
INSPECT L-0 REPLACING CHARACTERS BY " ".
WRITE REC-LEXCEL FROM LLL.
WRITE REC-LEXCEL FROM L-30.
WRITE REC-LEXCEL FROM L-4.
WRITE REC-LEXCEL FROM L55.
MOVE 2 TO L. MOVE 1 TO WMM.
MOVE 97 TO WAA.
MOVE 1 TO TIENDA.
MOVE 5 TO X.
SIGUE. MOVE WAA TO ANO-VEN.
MOVE TIENDA TO TDA-VEN.
MOVE WMM TO MES-VEN.
IF WAA = 10 GO FIN.
IF WMM = 13
INSPECT L-5 REPLACING ALL " " BY " "
INSPECT L-ENE REPLACING ALL " " BY " "
INSPECT L-FEB REPLACING ALL " " BY " "
INSPECT L-MAR REPLACING ALL " " BY " "
INSPECT L-ABR REPLACING ALL " " BY " "
INSPECT L-MAY REPLACING ALL " " BY " "
INSPECT L-JUN REPLACING ALL " " BY " "
INSPECT L-JUL REPLACING ALL " " BY " "
INSPECT L-AGO REPLACING ALL " " BY " "
INSPECT L-SET REPLACING ALL " " BY " "
INSPECT L-OCT REPLACING ALL " " BY " "
INSPECT L-NOV REPLACING ALL " " BY " "
INSPECT L-DIC REPLACING ALL " " BY " "
WRITE REC-LEXCEL FROM L-5
MOVE 1 TO WMM ADD 1 TO WAA GO SIGUE.
READ VENTA INVALID KEY move 0 TO CANT-VEN.
IF WAA > 96 MOVE 19 TO AA-N.
IF WAA < 96 MOVE 20 TO AA-N.
MOVE WAA TO BB-N.
MOVE ANO-X TO L-ANO.
IF WMM = 1 MOVE CANT-VEN TO L-ENE.
IF WMM = 2 MOVE CANT-VEN TO L-FEB.
IF WMM = 3 MOVE CANT-VEN TO L-MAR.
IF WMM = 4 MOVE CANT-VEN TO L-ABR.
IF WMM = 5 MOVE CANT-VEN TO L-MAY.
IF WMM = 6 MOVE CANT-VEN TO L-JUN.
IF WMM = 7 MOVE CANT-VEN TO L-JUL.
IF WMM = 8 MOVE CANT-VEN TO L-AGO.
IF WMM = 9 MOVE CANT-VEN TO L-SET.
IF WMM = 10 MOVE CANT-VEN TO L-OCT.
IF WMM = 11 MOVE CANT-VEN TO L-NOV.
IF WMM = 12 MOVE CANT-VEN TO L-DIC.
ADD 1 TO WMM.
GO SIGUE.
FIN. CLOSE LEXCEL VENTA.
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.
EXIT PROGRAM.