Re: Reading xls file

For a slightly different approach (output only) I create an XML file with the data I want and then XSLT transform to an excel sheet here is a short script I wrote to convert an excel-html file to an xslt http://www14.brinkster.com/colm/perl/perl-excel-xsl.html This approach has the benefit that

Getting CPAN working behind a firewall

Hi folks, I had a little trouble getting CPAN working inside a company firewall (MS Proxy Server) A little bit of reading and experimenting and I came up with a solution, might as well have this as part of the archive when people come a searching for just this gem. http://dearbbc.blogspot.com/200

Re: OR in a regex

Oops, that example I gave actually works It's always better to give the whole problem... (?http://learn.perl.org/>

OR in a regex

Hi Folks, Struggling to understand what is happening here... Example of text is Description Supports the management of the process to create and complete an order Actors SYSTEM Pre-Conditions A Service Instance may have been selected for the purchase This regex extracts the text /Description([^

NOT in a regex?

Hi Folks, I'm trying to pull a use case description out of a text file (actually an MS Word doc, but I've already used Win32:OLE to pull the text). The converted text comes out something along the lines of Version Change Date Changed By Change Description 1 Date A.N. Other Initial Revision.

Re: Help With OLE

this value. Any Ideas?? > > Thanks > > d > > > > -Original Message- > From: Colm Gallagher [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 26, 2004 2:55 AM > To: DiGregorio, Dave > Cc: perl_help > Subject: Re: Help With OLE > > Hi David,

Re: Help With OLE

to work because $LastCol was returning as a number, not a column letter reference, so I knocked together a quick and dirty converter - you may need to expand this slightly to handle AA etc, or post back to let me know how you do cell referencing. I learned from your code how to use named parameters w