|
|
Posted by Rik on 08/10/07 16:56
On Fri, 10 Aug 2007 18:47:05 +0200, Louis <t051315@hotmail.com> wrote:
> I am trying to use php to update a spreadsheet (MS Excel or OpenOffice
> Calc) with data from MySQL.
>
> I looked into PEAR::Spreadsheet_Excel_Writer if it will do the job. If I
> understand it correctly, it basically creates spreadsheets, but not
> opening an existing spreadsheet and then updating and saving it, which
> is what I want to do.
>
> Do you know if there is any package out there that can do what I
> described?
If you can get directly to the database, I'd advise skipping PHP all
together, and make an ODBC connection to MySQL, which Excel itself can
then use as it's datasource.
--
Rik Wasmus
Navigation:
[Reply to this message]
|