NYCPHP Meetup

NYPHP.org

[nycphp-talk] Linking Excel to PHP/MySQL (older versions)

Freedman, Tom S. Thomas.Freedman at ubs.com
Thu Jan 8 11:05:18 EST 2004


The most recent versions of Excel (at least in Office XP and Office 2003)
allow you to publish the spreadsheet as a .htm file and autorepublish the
file every time the worksheet is saved.  You could then parse the file into
your PHP site, or just link to the HTML file directly (though it'd only look
as nice as the spreadsheet itself).

-----Original Message-----
From: jon baer [mailto:jonbaer at jonbaer.net] 
Sent: Wednesday, January 07, 2004 4:35 PM
To: talk at lists.nyphp.org
Subject: [nycphp-talk] Linking Excel to PHP/MySQL (older versions)

greetings ...

a client is looking for a method to enable the ability where they could open
an excel doc, edit on the fly, and tie the content in with a website using a
template like say smarty ...

i have not read much up on "smart tags" but if content was tagged in smarty
like such:

{home_team.name} {home_team.score}

is there a dynamic way (macro, etc) to enable the content of the excel doc
to be posted to a site?  i had tried to convince the guy to ditch the excel
so i could do it online but he is someone more comfortable w/ excel only ...

what is the solution if i wanted to keep his doc and my site in sync?
thanks in advance for any suggestions.

- jon

pgp key: http://www.jonbaer.net/jonbaer.asc
fingerprint: F438 A47E C45E 8B27 F68C 1F9B 41DB DB8B 9A0C AF47

_______________________________________________
talk mailing list
talk at lists.nyphp.org
http://lists.nyphp.org/mailman/listinfo/talk


Please do not transmit orders or instructions regarding a UBS account by
email. The information provided in this email or any attachments is not an
official transaction confirmation or account statement. For your protection,
do not include account numbers, Social Security numbers, credit card
numbers, passwords or other non-public information in your email. Because
the information contained in this message may be privileged, confidential,
proprietary or otherwise protected from disclosure, please notify us
immediately by replying to this message and deleting it from your computer
if you have received this communication in error.  Thank you.

UBS Financial Services Inc.
UBS International Inc.




More information about the talk mailing list