[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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