Perl's Spreadsheet::ParseExcel and Spreadsheet::WriteExcel are great for
this purpose. Find them on a CPAN site near you.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of Don Read
> Sent: Thursday, June 14, 2001 3:43 PM
> To: Terminal Velocity
> Cc: [EMAIL PROTECTED]
> Subject: RE: help exporting to spreadsheet
>
>
>
> On 14-Jun-01 Terminal Velocity wrote:
> > I would like to use MySQL to manage my company data, but my clients
> > want all their information sent to them in an Excel spreadsheet.
> > Presently I use Access, and export a SELECT statement into
> Excel, and
> > then make a couple changes to the Excel file (I just high-lite the
> > updated data).
> >
> > I want to change the database to MySQL on a Linux box, but
> the biggest
> > issue is being able to export into Excel. I know I can export to a
> > tab-delimited text file, but I would prefer to do it all in
> one step.
> >
> > Any ideas?
> >
>
> I've used *.csv (comma seperated values) for a web-site; IRC,
> Excel is the default application for these.
> This may not be true anymore, haven't messed with Windows in ages.
> & I've heard there is a Perl package that speaks *.xls
>
> Regards,
> --
> Don Read [EMAIL PROTECTED]
> -- It's always darkest before the dawn. So if you are going to
> steal the neighbor's newspaper, that's the time to do it.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
