Geek Answers Handbook

What do I use to display CSV data in graph form?

I have a set of data stored in text files, which I now put in a CSV file through Perl. The data in question should now be displayed on the chart.

What are your suggestions? XML has been proposed, but XML cannot put data in a chart.

Ideally, what will happen: the data will be decoded from a text file, placed in an Excel spreadsheet and displayed in a chart, all with one bit of code, since they have many such text data files.

Perl, XML, C, C ++, C #, and VB are available.

+4
source share
5 answers

With Perl, you can use the Win32::OLE module to automate the placement of data in an Excel spreadsheet and display it on a chart.

You need to be familiar with the OLE library to understand what methods / properties you need to call and set.

+1
source

Spreadsheet::WriteExcel is a great CPAN module for creating Excel files in Perl.

In particular, look at Spreadsheet::WriteExcel::Chart , which allows you to create charts in an excel file.

+9
source

For my use, I found GD :: Graph to be a decent option for creating PNG charts. You can also use Chart :: Gnuplot .

I also have an example of creating a chart in an Excel document using Win32 :: OLE .

+2
source

What about gnuplot ? You can send data and commands to it through STDIN, which works very well in Perl or there are some.

+2
source

Chart :: Clicker is good. Its output is smaller than the pixels of GD :: Graph, and it supports transparent overlapping parts.

+1
source

More articles:


All Articles