Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 1715
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: 7233

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: 2422
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: 110
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: 7913
Location: Bellevue, IA

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
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
This topic is locked: you cannot edit posts or make replies. RANDOM Function in COBOL swapnil781 COBOL Programming 2 Tue Nov 15, 2016 6:17 pm
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts COBOL Version 6.1 Virendra Shambharkar COBOL Programming 5 Tue Nov 01, 2016 11:24 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us