Help Perl and Excel

Hi,
I have an excel file and want to read this file using Perl in cygwin.
and i want to write data in txt file

Excel file format

1100028 : /////// : ///////
1100028 : ///==== : /////////
1100030 : ///// : ///////
1100031 : ///// : /////

Ouput File Should look like

1100028:3:7:7:3:7:7:7
1100030:2:5:5:7:7
1100031:1:5:5

above means
for 1100028, there are 3 pairs with min and max values and for 1100030,
there are 2 paris with min and max values, for 1100031, there is 1 pair
with min and max values.

Can anybody help pls

u can contact me shethaas@xxxxxxxxx

.

Relevant Pages

  • Re: export to excel
    ... >> with a CGI Perl. ... My CGI allows output to HTML table by Template.pm ... >> output in excel file. ... > write the results from your query out to a .csv file. ...
    (comp.lang.perl.misc)
  • Help Perl and Excel
    ... I have an excel file and want to read this file using Perl in cygwin. ... Excel file format ...
    (comp.lang.perl.misc)
  • Re: Error in Spreadsheet module
    ... i'am new in newbie in Perl, and i try i convert a excel file in csv ... I install the Spreadsheet-ParseExcel-0.32.tar.gz module in my linux ... By using CPAN (perl -MCPAN -e shell) or manually? ...
    (comp.lang.perl.modules)
  • Re: Write Excel and Open file from CGI
    ... I have a DOS batch file which has perl script that runs at the end. ... script fetches information from different files and database and generates ... Is there a way I can open the excel from CGI and display on ... to extract the contents of the Excel file and display ...
    (perl.beginners)
  • Re: How to convert csv file to excel
    ... Can anybody help me how to convert csv file to excel file using Perl ... or Shell scripts? ...
    (perl.beginners)