Re: How to grab data in text file and pass to excel charts using perl?

Also see Using Win32::OLE and Excel - Tips and Tricks

I'm not really a human, but I play one on earth.
Old Perl Programmer Haiku ................... flash japh

Comment on Re: How to grab data in text file and pass to excel charts using perl?

Replies are listed 'Best First'.
Re^2: How to grab data in text file and pass to excel charts using perl? by pvaldes (Chaplain) on Aug 31, 2011 at 14:27 UTC
well, strictly not related with your question, but if you have a lot of data in a text file and your goal is to produce some nice, portable and complex graphs maybe you should consider either to use any of the plethora of graph modules from cpan... or, to pass this data to R, octave ect...You can create a lot of super-cool graphs with these programs that excel simply can't do, take a look at: `http://addictedtor.free.fr/graphiques/` You can invoke R from perl with: `use Statistics::R; my $r_connection = Statistics::R->new();` [download] Just another point of view. You probably don't need perl to load or import a text file to excel, you can do this directly from excel	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: How to grab data in text file and pass to excel charts using perl?
by pvaldes (Chaplain) on Aug 31, 2011 at 14:27 UTC

well, strictly not related with your question, but if you have a lot of data in a text file and your goal is to produce some nice, portable and complex graphs maybe you should consider either to use any of the plethora of graph modules from cpan...

or, to pass this data to R, octave ect...You can create a lot of super-cool graphs with these programs that excel simply can't do, take a look at:

http://addictedtor.free.fr/graphiques/

You can invoke R from perl with:

use Statistics::R;
my $r_connection = Statistics::R->new();
[download]

Just another point of view. You probably don't need perl to load or import a text file to excel, you can do this directly from excel

[reply]
[d/l]
[select]