I'm told that this is relatively easy to do using VBScript... Besides the fact that I don't know VBS I would like to do it the Perl way :)
-----Original Message----- From: David Olbersen [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:56 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Excel spreadsheet: creating charts Rich, I know for a fact that you can generate any of the formulas and data you might need with Spreadsheet::WriteExcel -- I'm not so sure about the graphs though. I think those would still need to be done manually. -------------------------- David Olbersen iGuard Engineer 11415 West Bernardo Court San Diego, CA 92127 1-858-676-2277 x2152 > -----Original Message----- > From: Richard Fernandez [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 12, 2003 7:55 AM > To: [EMAIL PROTECTED] > Subject: Excel spreadsheet: creating charts > > > We have a manual process in place to create Excel worksheets > that contain > bar charts. I'm trying to automate this process using perl. > The problem is > that I don't know how to access the underlying formulas, in > Excel, that > generate the charts. Our current process is as follows: > > 1) Generate a space separated list of stats on Sun box using sar(1). > 2) cut and paste this list into a pre-existing Excel > spreadsheet which then > automatically > re-draws the charts based on the new data. > > What I need help with is figuring out how to create a sheet with the > necessary charts. Is this possible to do using > Spreadsheet::WriteExcel? Is > there a way to determine form the existing worksheet what the > formula is for > the charts. > > I'm not opposed to doing this a different/better way if anyone has any > suggestions, but I'd like to avoid generating csv files since > this would > require a manual "import" into Excel. > > Any help is much appreciated! > > Rich > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
