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@yahoo.com

Help Perl and Excel--Multiposted

"Kahan" wrote:
>> [ snip multiposted message ]

This message has been multiposted as indicated by these message IDs:



Multiposting is generally considered impolite in usenet. For an
explanation, please see:

http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

--
msg_hash: 88 - 6d4a723abc2990d7a0306c3a684f8a6b

Re: Help Perl and Excel

Kahan wrote:
> Hi,
> I have an excel file and want to read this file using Perl in cygwin.

Have a look at H. Merijin Brand's excellent Spreadsheet::Read.

Jim Ford

Re: Help Perl and Excel--Multiposted

me@davidfilmer.net wrote:
>
> This message has been multiposted as indicated by these message IDs:
>
>
>
> Multiposting is generally considered impolite in usenet. For an
> explanation, please see:
>
> http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

Much better. However I would still like to see the group names added.
Patially this is just out of interest.

More significanly with the group names included, those people who don't
think the "education" argument is sufficient to justify this bot as a
public service cannot deny that it is providing a public service by
assiting interested parties to follow both threads.

BTW: I think your formatting of the message IDs is non-canonical. AFAIK
they should conventionally be prefixed news: xor enclosed in <>.

Re: Help Perl and Excel--Multiposted

Brian McCauley schreef:

> BTW: I think your formatting of the message IDs is non-canonical.
> AFAIK they should conventionally be prefixed news: xor enclosed in <>.

No. The is meant to give a news-client a chance if the URI
gets wrapped.

See the APPENDIX section of RFC 1738 (or Appendix C of RFC 3986). In
those days (1994), the proposed format was but the
"URL:" part never got popular (and even causes problems with some
clients).


The prefix "URL:" (with or without a trailing space) was recommended
as a way to used to help distinguish a URL from other bracketed
designators, although this is not common in practice.
[...]
Yes, Jim, I found it under "http://www.w3.org/Addressing/",
but you can probably pick it up from net/rfc/>. Note the warning in ietf/uri/historical.html#WARNING>.


The 'news:' should be there, not just because popular clients
irrevocably default to 'mailto:' but because it is RFC compliant.

See RFC 3986 (updates 1738; obsoletes 2732, 2396, 1808).

--
Affijn, Ruud

"Gewoon is een tijger."