is it possible to create chart using REXX



IBM's Command List programming language & Restructured Extended Executor

is it possible to create chart using REXX

Postby SKANDA » Thu Aug 04, 2016 7:58 pm

Hi,
I would like to generate the chart( pie chart ) for the data I have using REXX.
The chart can be create in any of the following (excel, Msword)
Please help me out to solve this scenario.
SKANDA
 
Posts: 30
Joined: Thu Aug 04, 2016 7:50 pm
Has thanked: 17 times
Been thanked: 0 time

Re: is it possible to create chart using REXX

Postby Pedro » Thu Aug 04, 2016 9:26 pm

It is not clear to me what you are asking for. Neither Excel nor MS Word work on z/OS. Are you asking to create a file on z/OS, download it to Windows, then have it display a pie chart?
Pedro Vera
User avatar
Pedro
 
Posts: 684
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times

Re: is it possible to create chart using REXX

Postby prino » Fri Aug 05, 2016 1:52 am

REXX is a Turing-complete language. It can do anything you want. Just decode the internal format of charts in Excel and Vijaj is your uncle!
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: is it possible to create chart using REXX

Postby Robert Sample » Fri Aug 05, 2016 2:56 am

Just decode the internal format of charts in Excel and Vijaj is your uncle!
The Microsoft Excel Binary File Format Structure document is 1124 pages in version 4.2, so you might need a little time to do what you want.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: is it possible to create chart using REXX

Postby SKANDA » Fri Aug 05, 2016 9:44 am

Pedro wrote:It is not clear to me what you are asking for. Neither Excel nor MS Word work on z/OS. Are you asking to create a file on z/OS, download it to Windows, then have it display a pie chart?

Thanks for your reply

My actual question is, how to create a pie chart using Rexx coding :?
And I want to display that generated pie chat in ( Ms word or Excel)..Is this possible??
SKANDA
 
Posts: 30
Joined: Thu Aug 04, 2016 7:50 pm
Has thanked: 17 times
Been thanked: 0 time

Re: is it possible to create chart using REXX

Postby steve-myers » Fri Aug 05, 2016 12:30 pm

SKANDA wrote:My actual question is, how to create a pie chart using Rexx coding :?

You could probably create a text "pie" chart using Rexx, though I think you would find it rather difficult.
SKANDA wrote:And I want to display that generated pie chat in ( Ms word or Excel)..Is this possible??

If you created the chart, it would be rather easy to create a text data set, send the data set to a Windoze work station and load it into M$ Word.

All in all, you'd be better off shipping the data to a Windoze work station in a CSV formatted data set data set, loading the data set into Excel or something similar, and using Excel to create the "pie" chart. In 2002 through 2006 I was involved in a project to extract SMF data and use Excel to make pretty charts from the data.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: is it possible to create chart using REXX

Postby SKANDA » Fri Aug 05, 2016 3:53 pm

thank you steve,
As of now my REXX code will perform some calculation and export the output result to the csv file.so now I want to create a pie chart for those output data which is in csv file. And also could you pls give any sample code ? to resolve this task.
SKANDA
 
Posts: 30
Joined: Thu Aug 04, 2016 7:50 pm
Has thanked: 17 times
Been thanked: 0 time

Re: is it possible to create chart using REXX

Postby prino » Fri Aug 05, 2016 4:48 pm

Moderators, please close this thread!

The TS is obviously totally clueless and continues to run in circles!
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: is it possible to create chart using REXX

Postby SKANDA » Fri Aug 05, 2016 6:05 pm

sorry for the inconvenience prino,
pls try to understand my question and give some solution,,,..
is there any rexx syntax or rexx code to create pie chart in excel...

many thanks,
SKANDA.
SKANDA
 
Posts: 30
Joined: Thu Aug 04, 2016 7:50 pm
Has thanked: 17 times
Been thanked: 0 time

Re: is it possible to create chart using REXX

Postby enrico-sorichetti » Fri Aug 05, 2016 6:25 pm

is there any rexx syntax or rexx code to create pie chart in excel...


NOT on the mainframe

as already told,
1 -create a csv file ( using REXX or whatever other language of Your choice )
2 - download it to the windows workstation
3 - import it into an EXCEL spreadsheet
4 - create the graphic in any format supported.

but You might find interesting
http://www.rexxinfo.org/html/rexxinfo1. ... exx-HowTos

but still You will have to run step 1 on the mainframe
after that You might be able to automate ( using ooRexx on Your Windoze )
steps 2, 3 and 4

anyway topic locked to prevent further noise
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Next

Return to CLIST & REXX

 


  • Related topics
    Replies
    Views
    Last post