Perl and Excel

[Amit]

Hi All
I am trying to put a data in excel sheet from a data file using perl
language.
Whenever the line count of data files crosses 20,000, perl fail to
process the file.

I will be greatful if someone help me out of this problem.

Thanks in Advance
Amit

 

[A. Sinan Unur]

I am trying to put a data in excel sheet from a data file using perl
language.
Whenever the line count of data files crosses 20,000, perl fail to
process the file.

I will be greatful if someone help me out of this problem.

What have you done so far? There are quite a few ways of accomplishing this
task.

Have you read the posting guidelines?

Sinan

 

[Marcel Müller]

I am trying to put a data in excel sheet from a data file using perl
language.
Whenever the line count of data files crosses 20,000, perl fail to
process the file.

I will be greatful if someone help me out of this problem.

Write a plain text file with tab separated values and name it *.xls.
Excel will open it. That is that way SAP creates Excel files and it is
very reliable. (In contrast to many other methods.)
However, after 65535 lines the story is finally over since Excel can't
handle more. (Not absolutely sure if this is still true for Excel 2003)

# Write @line to tab separated values.
print XLSFILE join("\t", map { s/\"/\"\"/g; "\"$_\"" } @line), "\n";


Marcel