Excel File in PERL

[14anand]

Hi friends....
I need a code in PERL script for converting a text file to a excel file(.xls)....

[KevinADC]

OK, what have you tried so far?

[miller]

Here's the best module I know of for creating excel files:
cpan Spreadsheet::Wr iteExcel

And here's how to install them.
cpan faq: How to install Perl Modules

- Miller

[14anand]

Junk values written while Writing Excel in PERL

hi all...

I am able to write a excel file from a text file.But some junk value is written in to the columns of the file...

[miller]

What method are you using to create the Excel file? Are you using a specific cpan module?

There is no way for us to help you unless you actually tell us exactly what you are doing.

- Miller

[KevinADC]

hi all...

I am able to write a excel file from a text file.But some junk value is written in to the columns of the file...

OK, thank you for sharing that exciting news with us.... ;)

[miller]

14anand,

Since it appears that this is a continuation of the previous thread that you've started on this forum, I'm merging those two threads.

If you really want help then you should both start providing more information in your questions, and responding when people offer you their assistance.

We are not going to be enticed to continue to help you further it if does not appear that you are involved.

- Miller

[14anand]

Miller,

thanks for your comments..

I am able to write an excel file from a text file using Spreadsheet ::WriteExcel module.I am using Split function in Perl to seperate the text and write it in a excel file.When i write it i am getting some junk values also being written in the columns..

[14anand]

Writing in Excelsheet using PERL

I am able to write an excel file from a text file using Spreadsheet ::WriteExcel module.I am using Split function in Perl to seperate the text and write it in a excel file.When i write it i am getting some junk values also being written in the columns.I don't want these junk values to be printed.Can any one suggest me a solution to this..

[amitwadhwa]

I am trying to write to an excel file repeatedly. I create a new workbook with the SPreadsheet::Wr iteExcel module.

I need to close that file, do some more computations, come back and then add to the excel file. Is there a file open option in the module? If not, what is the best way of doing it then?

Thanks in advance