|
Posted by Kahan on August 16, 2006, 9:25 am
Please log in for more thread options
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
|
|
Posted by me on August 16, 2006, 9:29 am
Please log in for more thread options
>> [ 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
|
|
Posted by Brian McCauley on August 20, 2006, 12:05 pm
Please log in for more thread options
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 <>.
|
|
Posted by Dr.Ruud on August 21, 2006, 6:51 am
Please log in for more thread options
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 <enclosing> 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 <URL:scheme:...> but the
"URL:" part never got popular (and even causes problems with some
clients).
<quote source="rfc2396">
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 <ftp://ds.internic.
net/rfc/>. Note the warning in <http://www.ics.uci.edu/pub/
ietf/uri/historical.html#WARNING>.
</quote>
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."
|
|
Posted by Jim Ford on August 16, 2006, 9:42 am
Please log in for more thread options
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
|
| Similar Threads | Posted | | Perl and Excel | April 6, 2007, 1:06 am |
| OLE Module - Need to convert Excel VB Macro to perl | August 3, 2005, 9:06 am |
| OLE Excel AutoFilter | September 10, 2006, 4:28 pm |
| Excel Data conversion | July 27, 2004, 2:37 pm |
| Problem with Name of Excel Chart | September 22, 2005, 9:21 am |
| DBD:Excel on unix machine | March 9, 2006, 11:18 am |
| Everything but the column: win32::OLE Excel fun | June 7, 2006, 9:07 pm |
| Writing row at a time in Excel using OLE | June 14, 2007, 1:43 pm |
| How to write into existing Excel Spreadsheets? | July 13, 2004, 1:24 pm |
| Can I write Macros in excel workbook ? | October 8, 2004, 7:50 am |
|
XML Sitemap