Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
how to declare HTML tags in cobol program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
rekha rajendran

New User


Joined: 06 Feb 2013
Posts: 2
Location: india

PostPosted: Wed Feb 06, 2013 10:38 am    Post subject: how to declare HTML tags in cobol program
Reply with quote

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
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1868
Location: UK

PostPosted: Wed Feb 06, 2013 1:27 pm    Post subject:
Reply with quote

The sam way as you declare any other data. (Does Excel use html tags?)
Back to top
View user's profile Send private message
rekha rajendran

New User


Joined: 06 Feb 2013
Posts: 2
Location: india

PostPosted: Wed Feb 06, 2013 3:01 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Wed Feb 06, 2013 3:07 pm    Post subject: Reply to: how to declare HTML tags in cobol program
Reply with quote

Code:
Beans|Potatoes|Salad
Green|White|None
Runner|Red|None


I've never heard of needing to put HTML tags to get Excel to read data.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2441
Location: Netherlands, Amstelveen

PostPosted: Wed Feb 06, 2013 3:12 pm    Post subject:
Reply with quote

For lost of examles Google on this : Creating a Dynamic Excel Using HTML
Back to top
View user's profile Send private message
Jose Mateo

Active User


Joined: 29 Oct 2010
Posts: 111
Location: Puerto Rico

PostPosted: Wed Feb 06, 2013 7:41 pm    Post subject: Reply to: how to declare HTML tags in cobol program
Reply with quote

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.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8154
Location: East Dubuque, Illinois, USA

PostPosted: Wed Feb 06, 2013 10:35 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts ALPHABETIC check in COBOL vidyaa COBOL Programming 8 Thu Aug 17, 2017 7:13 pm
No new posts XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us