how to declare HTML tags in cobol program

rekha rajendran · New User Joined: 06 Feb 2013 Posts: 2 Location: india

How to declare html tags in cobol program in order to generate an excel with the data .The data from mainframe has to displayed in the excel with its headers. Please let me know if anybody could help me on this

Nic Clouston · Posted: Wed Feb 06, 2013 1:27 pm

The sam way as you declare any other data. (Does Excel use html tags?)

rekha rajendran · New User Joined: 06 Feb 2013 Posts: 2 Location: india

to place the data in the table cells we have to use html tags and it is not the same way as we declare usual data

Bill Woodger · Posted: Wed Feb 06, 2013 3:07 pm

PeterHolland · Posted: Wed Feb 06, 2013 3:12 pm

For lost of examles Google on this : Creating a Dynamic Excel Using HTML

Jose Mateo · Posted: Wed Feb 06, 2013 7:41 pm

Good day to all!

Like Bill has mention you don't have to use HTML tags to format data in Excel. You could use any special character as a delimiter as long as you specify it during the process of importing the data in Excel. Normally you will use the comma as a delimiter (CV). In the Cobol program you will format your output record with comma value between each field that include your first record which will contain your heading for each cell. After running your program you will download your output file to a text file. Then you will open a Excel spread sheet where you will import your external file using the comma value as a delimiter. You got your work already cut-out.

Robert Sample · Posted: Wed Feb 06, 2013 10:35 pm

Be aware that COBOL does not "do" HTML. You can code up the tags as variables in COBOL, but this is not something COBOL will do for you -- you will need to hand-code each tag as a COBOL variable. COBOL handles XML, but not HTML.