Invoke PERL from unix/linux, process and writing o/p data Excel sheet (Spread sheet)

[pvenu]

Hi,
I know basic perl (regular expressions, pattern matching, string manipulation, reading writing into text files).

Yet, my requirement is to read an input text file -> process this input file through a Perl script and the output generated from this script is to be written into an Excel sheet file (into each cells of the sheet).

Can you please provide me pointers on this. Example code for reading and writing into Excel (spread) sheets using PERL would be of great help.

I want to execute the PERL script from Unix / Linux OS.

Thanks,
Venu.

[Kelicula]

I believe that excel is able to process CSV files, so you should create a "comma separated values" file with the perl program. Like so:

open(INPUT, "<theFirstFile.ext") or die "could not open: $!";
 
# do what ever
 
close(INPUT);
 
open(OUTPUT, "theFile.csv") or die "could not open: $!";
 
 

Make sure you separate all the cells with a comma in your output file.
Open a CSV file and examine how it is constructed. (I really don't know)
Then mimic that with your perl output.

Here ya go Click here

Than Excel will be able to open the theFile.csv file and display it properly.