java programming - to display the excel bar charts
Posted by arrolwar (arrolwar), 11 May 2005hello friends ....,
I am new to the site.....let me tell abt me ....I am just a student ..... preparing a tool for the company Alcatel in germany ... I promised that i will do it in Java .....the task is simple ....just to retreive the data from the database ..... manipulate the data and write the data into the excel sheet so that the bar chart with the same data should be poped up......the bar chart should have the title and the date as per the database.....
the small piece of data is dumped into my computer which i was able to maintain it in mysql and able to connect java through JDBC...i made some empty templates of excel sheets into which the output has to be written and according to that output the bar charts should be generated ....the department ppl want this tool to be so simple that the user has to just enter the specifications from the simple GUI as per my program ....and get the output in the form of barcharts.....actually my idea was to make charts or graphs entirely in java programming like using chart.java or graph.java.....it was little bit complicated ...the ppl working with me also told me that i have chosen a big and complicated procedure....but cant help it ......
I promised them as i dont even know java well ........but now i am in the middle of the road ....i hope all the ppl of the opentalk will help me in my project .....i have my future depending on this tool......
if u have any sort of doubts .regarding this mail.......plz do write to me .....hoping for the replies....
Posted by admin (Graham Ellis), 11 May 2005You've certainly chosen a lot of technologies to use ...
Your question reminded me of a sample program that we use on one of our Java courses - see http://www.wellho.net/resources/J953.html for a description of the training module and have a look at the various source code examples there.
The training notes of this module are actually release under an open training notes license ... so you'll find that there's a link on fromthe page I've given you above to some quite complete documentation in a .pdf file.
This is pure Java and Java graphics, by the way. Excel is another matter - I'm quites used to interfacing to MicroSoft formats in Perl but not so much in Java.
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: email@example.com • WEB: http://www.wellho.net • SKYPE: wellho