[EMAIL PROTECTED] wrote:
> Hi,
> Not sure if that is what you want, but I did it once by retrieving
> information from MySQL database and then writing it to .csv file.
> When user clicks in .csv file link, it opens in Excel (IE only)
> Worked for me,
> Regards,
> VM
The real question is what do you want the Excel spreadsheet to be? if
you have formulas, etc, then would use Spreadsheet::WriteExcel. But if you can
populate the rows the way you want, then the .csv is the easiest way to do the
processing. As along as you provide the necessry key fields on each line, then
the user can do whatever they want with the data.
Wags ;)
>
> -----Original Message-----
> From: [EMAIL PROTECTED] on behalf of
> Sharp, Craig Sent: Mon 3/6/2006 4:09 PM
> To: perl-unix-users@listserv.ActiveState.com
> Cc:
> Subject: [Perl-unix-users] Populating a spreadsheet from files
>
>
>
> Hi all,
>
>
>
> Does anyone have an example of using Perl to populate an excel
> spreadsheet with data from multiple files. I need to do this
> automatically.
>
>
>
> Best regards,
>
> Craig Sharp
>
>
>
>
>
> Quicken Loans | Unix Engineer | Direct: 734.805.7839 | Fax:
> 734.805.5513 | [EMAIL PROTECTED]
>
> <http://www.quickenloans.com/>
>
> The contents of this e-mail are intended for the named addressee
> only. It contains information that may be confidential. Unless you
> are the named addressee or an authorized designee, you may not copy
> or use it, or disclose it to anyone else. If you received it in error
> please notify us immediately and then destroy it.
>
>
>
>
>
>
> =====================================================================
>
> Please note that this e-mail and any files transmitted with it
> may be privileged, confidential, and protected from disclosure
> under applicable law. If the reader of this message is not the
> intended recipient, or an employee or agent responsible for
> delivering this message to the intended recipient, you are
> hereby notified that any reading, dissemination, distribution,
> copying, or other use of this communication or any of its
> attachments is strictly prohibited. If you have received this
> communication in error, please notify the sender immediately by
> replying to this message and deleting this message, any
> attachments, and all copies and backups from your computer.
>
> _______________________________________________
> Perl-Unix-Users mailing list
> Perl-Unix-Users@listserv.ActiveState.com
> To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
*******************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
*******************************************************
_______________________________________________
Perl-Unix-Users mailing list
Perl-Unix-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
