Create chart automatically?
11 December 2009, 04:04 PM
#1
Scooby Senior
Thread Starter
Join Date: Dec 2000
Location: North Wales
Posts: 5,826
Likes: 0
Received 0 Likes
on
0 Posts
Create chart automatically?
I need to create a chart daily, weekly, monthly etc and I need it to happen automatically.
I am sending data from the mainframe to a server, and I need to be able to create a chart from that automatically using excel.
I'm a mainframe boy, so dont' really know much about the server side, any ideas?
Kicking off a script isn't a problem as I can use Tivoli for that, but I don't really know how to automate starting up excel and then importing the data (which I presume will have to be comma separated?) into and creating the chart.
Any help greatly appreciated!
Geezer
I am sending data from the mainframe to a server, and I need to be able to create a chart from that automatically using excel.
I'm a mainframe boy, so dont' really know much about the server side, any ideas?
Kicking off a script isn't a problem as I can use Tivoli for that, but I don't really know how to automate starting up excel and then importing the data (which I presume will have to be comma separated?) into and creating the chart.
Any help greatly appreciated!
Geezer
11 December 2009, 05:06 PM
#2
Scooby Regular
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
Id use something like SQL reporting services to do this, but theres plenty of examples of excel automation from Wscript or even powershell - heres one from a quick google Automated Excel Tables and Charts
David
David
Thread
Thread Starter
Forum
Replies
Last Post
Sam Witwicky
Engine Management and ECU Remapping
17
13 November 2015 10:49 AM