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::WriteExcel

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

- Miller

[14anand]

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]

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::WriteExcel 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