469,343 Members | 5,380 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,343 developers. It's quick & easy.

Excel File in PERL

Hi friends....
I need a code in PERL script for converting a text file to a excel file(.xls)....
Mar 13 '07 #1
9 3943
KevinADC
4,059 Expert 2GB
OK, what have you tried so far?
Mar 13 '07 #2
miller
1,089 Expert 1GB
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
Mar 13 '07 #3
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...
Mar 22 '07 #4
miller
1,089 Expert 1GB
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
Mar 22 '07 #5
KevinADC
4,059 Expert 2GB
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.... ;)
Mar 22 '07 #6
miller
1,089 Expert 1GB
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
Mar 22 '07 #7
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..
Mar 23 '07 #8
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..
Mar 26 '07 #9
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
Jul 7 '08 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by toffee | last post: by
4 posts views Thread by rpace | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.