• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

Creating native excel reports from perl

Hi Experts,

I want to create a excel report as given in this example.
http://lena.franken.de/perl_hier/excel.html
But, I do not have the libs they are using.

use Date::Calc;
use Spreadsheet::WriteExcel;
use Spreadsheet::WriteExcel::Utility;


Where can I download these?  or is there any other better way to do excel report from perl?
0
ambuli
Asked:
ambuli
  • 4
  • 2
1 Solution
 
tel2Commented:
They are called "modules" in Perl, and they are here:
  www.cpan.org

Type the module name in the Search box.


I don't know other ways to do Excel in Perl.
0
 
tel2Commented:
...apart from writing it as an HTML table, and giving the filename a .xls extension.  If you want more info on this, let me know.
0
 
ambuliAuthor Commented:
Thank you.  Let me know how to create HTML, if it is simple.  Thanks.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
tel2Commented:
Hi ambuli,

Write a file which contains this kind of thing:
<table>
        <tr>
                <td colspan="2" align="center">Spanned Heading</td>
        </tr>
        <tr>
                <td width="30%"><b>Data 1</b></td>
                <td><font color="red">Data 2</font></td>
        </tr>
</table>

Open in new window

And make the extension of the file .xls
When you open the file, it should open in Excel.  Works for me.

However, I doubt you can do fancy stuff like formulas, but it might be OK for reports.
0
 
ambuliAuthor Commented:
Thanks tel2.  
0
 
tel2Commented:
A pleasure doing business, ambuli...again.

You're busy today.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now