Click here to get back home

Create Excel chart from spreadsheet on Un*x?
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Create Excel chart from spreadsheet on Un*x? fishfry 12-28-2006
Posted by fishfry on December 28, 2006, 11:28 pm
Please log in for more thread options

I'm using Spreadsheet::WriteExcel::FromDB::Query to create spreadsheets
directly from a Mysql database. It's very cool.

Now I'd like to obtain a chart, or graph, from the spreadsheet. It's
easy to do with a few Excel keystrokes; but I want to do it
programmatically.

I gather that if I were to get Perl running on a Windows box I could use
Win32::OLE to control Excel from within Perl. But then I'd have to use a
Windows box, learn OLE/Active-X, etc. I'd rather not go down that path
if I don't have to.

Is there a way for me to make a chart from a spreadsheet on a Un*x box?
Or, is there perhaps some open-source spreadsheet that can be used in
place of Excel?

Posted by Martijn Lievaart on December 29, 2006, 2:28 am
Please log in for more thread options

On Thu, 28 Dec 2006 20:28:06 -0800, fishfry wrote:

> Is there a way for me to make a chart from a spreadsheet on a Un*x box?

As you have the raw data, why not use one of Perls many graphic modules
(optionally also writing the spreadsheet if needed)?

Or feed the data into gnuplot?

> Or, is there perhaps some open-source spreadsheet that can be used in
> place of Excel?

www.OpenOffice.org.

HTH,
M4
--
Redundancy is a great way to introduce more single points of failure.


Posted by fishfry on December 29, 2006, 3:18 am
Please log in for more thread options



> On Thu, 28 Dec 2006 20:28:06 -0800, fishfry wrote:
>
> > Is there a way for me to make a chart from a spreadsheet on a Un*x box?
>
> As you have the raw data, why not use one of Perls many graphic modules
> (optionally also writing the spreadsheet if needed)?
>
> Or feed the data into gnuplot?
>
> > Or, is there perhaps some open-source spreadsheet that can be used in
> > place of Excel?
>
> www.OpenOffice.org.
>


Thanks much. You're right, it's much easier to generate the chart
directly since that's the end product. There are a lot of charting
packages out there. At the moment I'm trying out ChartDirector from
these guys ... http://www.advsofteng.com/. So far so good.

Posted by Ron Savage on December 29, 2006, 4:56 pm
Please log in for more thread options


On Fri, 29 Dec 2006 19:18:51 +1100, fishfry wrote:

Hi

> packages out there. At the moment I'm trying out ChartDirector from
> these guys ... http://www.advsofteng.com/. So far so good.

CPAN is your friend: http://search.cpan.org/~darnold/DBIx-Chart-0.05/



Posted by jmcnamara on December 29, 2006, 4:13 am
Please log in for more thread options



fishfry wrote:
> I'm using Spreadsheet::WriteExcel::FromDB::Query to create spreadsheets
> directly from a Mysql database. It's very cool.
>
> Now I'd like to obtain a chart, or graph, from the spreadsheet.

If you use Spreadsheet::WriteExcel directly then you can get some
limited charting using an external template. See the following and the
examples in the charts directory of the distro:


http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/charts/charts.pod

John.
--


Similar ThreadsPosted
GD::Graph - Can it create a stock chart October 7, 2004, 10:42 am
Problem with Name of Excel Chart September 22, 2005, 9:21 am
SpreadSheet::Write Excel- Is there a way to set background color for entire worksheet? January 21, 2005, 12:56 pm
Spreadsheet-ParseExcel: Parsing various MS Excel file versions / grabing checkbox values? September 17, 2004, 3:11 am
Error in DBD::Chart (called from DBIx::Chart) May 19, 2006, 2:35 pm
PDF::Create (or alike) to create watermark for existing pdf file? June 11, 2006, 6:18 pm
Need help with Chart::OFC January 4, 2008, 10:04 pm
GD::Chart OO model October 27, 2004, 10:42 am
ANNOUNCE: Image::Magick::Chart V 1.01 June 13, 2005, 3:36 am
PDF::Create February 28, 2005, 11:28 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap