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
Joined: 29 Oct 2010 Posts: 110 Location: Puerto Rico
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.
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.