Excel -> CVS

[John Evans]

Does it require ASP and IIS? The perl script will be running in it's
native home... meaning Linux. If it will work in a Linux/Solaris
environment, where do I get such a creature? I searched CPAN for it and
came up empty.

Thanks...

On Tue, 8 Feb 2000, Jeremy Russell wrote:

> There is an an ADO module that you can check out.  It allows you to use
> ActiveX objects and it works reasonably well.  In my opinion, it is the best
> module to use if you are doing a lot with ASP PerlScript for IIS. 
> 
> -----Original Message-----
> From: John Evans [mailto:evansj at kilnar.com]
> Sent: Tuesday, February 08, 2000 12:53 PM
> To: Pikes Peak Perl Mongers
> Subject: Excel -> CVS
> 
> 
> Hiya,
> 	We're getting a "database" emailed to us once a week that is in
> Excel spreadsheet. Yeah, yeah... I know it's not a database, but try
> telling that to the sales gal on the other end...
> 
> 	Anyway, the data is to be used for a web application that is to be
> written in Perl. Anyone know of any modules that can read from Excel
> spreadsheets directly? If not, is there a way to convert the Excel
> spreadsheet to a comma-delimited file (CVS) or some othe format that is
> readable by Perl other than by manually opening the file and doing a "File
> | Save as..."?
> 
> 	I'm really flexible on what the end solution will be so long as I
> can feed the Excel spreadsheet to some program[1] that will produce
> results that a Perl script can access so that I don't have to manually
> convert the Excel spreadsheet every week.
> 
> 
> [1] The conversion program can be written in Perl, C, C++ or Java for all
> I care.
> 
> Mucho Gracias!
> 
> 

-- 
  .-.   John Evans <mailto:evansj at kilnar.com>
  /v\   http://evansj.kilnar.com/  telnet://spear.kilnar.com:1066/
 // \  GCS d- s+: a- C+++ U++++ P++ L++ E---- W+++ N+ o-- K w-- 
/(   )\ O M- V PS+ PE Y+ PGP- t-- 5-- X+ R+++ tv+ b++ DI++ D++ 
 ^^-^^  G e h--- r+++ z+++