C# Convert Cobol Copybook structure into Excel Spreadsheet
-
Hi All, Can anybody help me how to convert Copybook data into Excel SpreadSheet using C# .I am new to Copy book.The copybook structure as follows. *****Copybook1***** 05 IC-Record-ID PIC X(02) value'IC' 05 IC-TPA-ID PIC x(06) 05 IC-Employer-ID PIC X(09) 05 IC-Plan-ID PIC x(09) 05 IC-Employee-ID PIC X(30) 05 IC-Account-Type-Code PIC X(04) 05 IC-Plan-Start-Date PIC x(08) 05 IC-Plan-End-Date PIC x(08) 05 IC-Account-Status PIC 9(01) 88 IC-Acct-New value 1. 88.IC-Acct-Active value 2. 88,IC-Acct-Temp-Inactive value 3. 88.IC-Acct-Perm-InActive value 4. 05 IC-Auto-Deposit-Last-Alloc-Dt Pic x(08) 05 IC-Flex-Account-Options Pic x(02) 88 IC-Recurr-Expense value '01' 88 IC-Copay-Rollover value '02' 05 IC-Request_Legnth Pic s9(04)COMP. 05 IC-Subscriber-Person-ID-R REDEFINES IC-Subscriber-Person-ID Pic x(15) 10 IC-Plan-ID pic x(10) 10 IC-Post-BenOPTS-Array OCCURS 20 Times. 15 IC-Post-BenOpt PIC x(05). 10 IC-Plan-Status Pic x(01) 88 IC-Plan-New value '1' 88 IC-Plan-Active value '2' *****Copybook2***** 05 RB-RB-Record-D PIC X(02) Value'RB'. 05 RB-Employer-ID PIC X(09) 05 RB-Employee-ID PIC X(30) 05 RB-Details-Response-Code PIC X(09). ****Copybook3***** Employee-Account-Record 05 RC-Employee-ID PIC X(02) value'RC' 05 RC-Employer-ID PIC X(09) 05 RC-Employee-ID PIC X(30) 05 RC-Account-Type-Code PIC X(04) 05 RC-Plan-Start-Date PIC X(08) 05 RC-Plan-End-Date PIC X(08) 05 RC-Detail-Response-Code PIC(06) Once defined above structure . I have to give input file as sequential data file and expected output as spreadsheet Thanks & Regards Rao