generate excel graph in linux operating system

[Lim kiang Leng]

Hi ,

Is any one know how to generate an Excel graph in Linux or HP operating system.

Seem that i cant use the Win32::OLE because i am not in the microsoft OS.

I plan to generate the Excal graph and send out through email.


thanks,

 

[ChrisO]

Hi ,

Is any one know how to generate an Excel graph in Linux or HP operating system.

Seem that i cant use the Win32::OLE because i am not in the microsoft OS.

I plan to generate the Excal graph and send out through email.

You should do a Google for Excel and Unix for this ng. I'm not one to
say something's impossible, but some things are not worth the effort.
I'm not a huge Excel on Unix expert, hence I mention the Google, but
I've seen a lot of answers on building Excel output on Unix and the
answers are never encouraging.

If you've got absolutely no access to a Windows machine running Excel,
then I guess you may be in a really tight spot. But if you have any
access to a Windows machine running Excel, my approach, if I *had* to
"generate" from the Unix side would be to build a web service that would
allow me to RPC to the Windows machine, generate the Excel graph, and
hand it back to me on the Unix side. In today's day and age, I don't
see anything wrong with building a transparent interface to another
machine over the wire to get something like this done.

-ceo

 

[Mladen Gogala]

You should do a Google for Excel and Unix for this ng. I'm not one to
say something's impossible, but some things are not worth the effort.
I'm not a huge Excel on Unix expert, hence I mention the Google, but
I've seen a lot of answers on building Excel output on Unix and the
answers are never encouraging.

Funny thing, I've been using Spreadsheet:arseExcel and
Spreadsheet::Writexcel and never had any problems. When talking
about perl, I'd much rather search CPAN then Google. Look
on CPAN for modules containing the keyword "Spreadsheet".
Download the module(s) and write the spreadsheet. That's all
there is to it.

 

[Lim kiang Leng]

I just want to add on some thing,

is there any module can be use without install it ?

 

[Mladen Gogala]

I just want to add on some thing,

is there any module can be use without install it ?

Instal it in your own PERL5LIB

 

[Sherm Pendley]

Funny thing, I've been using Spreadsheet:arseExcel and
Spreadsheet::Writexcel and never had any problems.

Have you been using them to produce a graph, or to populate the sheet
with raw data? The OP wants a graph.

sherm--

 

[Sherm Pendley]

Is any one know how to generate an Excel graph in Linux or HP
operating system.

Must it be generated with Excel? There are several graphing modules on
CPAN that you can use, but they generate simple GIF or PNG images, and
they don't use Excel.

If it *must* be Excel, I'm afraid I don't see how that could be done
outside of Windows.

sherm--

 

[ChrisO]

Funny thing, I've been using Spreadsheet:arseExcel and
Spreadsheet::Writexcel and never had any problems. When talking
about perl, I'd much rather search CPAN then Google. Look
on CPAN for modules containing the keyword "Spreadsheet".
Download the module(s) and write the spreadsheet. That's all
there is to it.

But as far as I've ever heard, that's about the extent of it on Unix.
I've not seen that these can produce graphs nor can they manipulate
existing Excel workbooks. That's my understanding anyway. I'm aware of
these two modules, but I believe their functionality offers less than
what many post requests for.

Please correct me if I'm wrong, but this is all I've seen people claim
these two modules can do.

-ceo

 

[ChrisO]

Must it be generated with Excel? There are several graphing modules on
CPAN that you can use, but they generate simple GIF or PNG images, and
they don't use Excel.

If it *must* be Excel, I'm afraid I don't see how that could be done
outside of Windows.

I'd almost bet that it has to be Excel for him beause he's probably
producing these graphs for some management types and that's the only
"interface" they have/know is Excel...

I've actually both reduced my requirements complexity and impressed some
managers by getting them OUT of Excel, PowerPoint and Project and INTO
"the web" on several occasions like this by producing what they want
suitable for viewing in a web browser (which most managers almost
certainly have and can use) and then touting how "centralized" their
reports are now and how easy it is to disseminate and update this
information. Sometimes just SHOWING managers an alternative is all the
"help" they need and can be a big win for you, the developer.

So, OP, you may save yourself some time by going THAT route (and use
ImageMagick or any number of great Perl graphing tools) and putting your
data on a web server and just forgetting about Excel. If you can.
Sometimes, it's just not possible to convince otherwise or other
requirements make Excel (or application X) the steadfast rule.

-ceo