Excel sheet creation using perl

[rahatekarabhijeet]

I want to create excel sheet using perl, i had installed all the necessary modules from CPAN.

The perl program i taken from CPAN itself it is given below,

#!/usr/bin/perl -w
use warnings;
use strict;
use Excel::Template;
# Create the Excel template
my $template = Excel::Template->new(
    filename => 'test.xml',
);
# Add a few parameters
$template->param(
    HOME => $ENV{HOME},
    PATH => $ENV{PATH},
);
$template->write_file('test.xls');
 

and test.xml is

<workbook>
<worksheet name="tester">
<cell text="$HOME" />
<cell text="$PATH" />
</worksheet>
</workbook>
 

test.xls file is getting created but when i tries to open it i am getting following error,
Error loading document file filename
Incorrect file format

So help me for overcoming on this problem.

[miller]

I do not know why Excel::Template is not working for you as I have no experience with it. I suggest that you use Spreadsheet::WriteExcel instead, as it more commonly used and has a lot more features:

cpan Spreadsheet::WriteExcel

- M

[rahatekarabhijeet]

Thanks for your help,
according to your suggestion i used
Spreadsheet::WriteExcel for excel sheet generation and now i am able to
create excel sheet using perl.
Thanks once again....

[miller]

Thanks for your help,
according to your suggestion i used
Spreadsheet::WriteExcel for excel sheet generation and now i am able to
create excel sheet using perl.
Thanks once again....

Excellent. Glad I could help.

- Miller