Jump to content


Photo

PHP/Excel prob


  • Please log in to reply
2 replies to this topic

#1 s10ryan

s10ryan
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 27 July 2006 - 02:05 PM

I am building bar to show the daily goal and what they are at all through the day.
I am basing it pretty much of this one: http://www.wynia.org...tml-goal-meter/
The data that i want to pull from is on an Excel spreadsheet that is updated through out the day and also gets data off of mulitple other excel files. I just need to pull one # off that spread sheet and put it so it will automatically update the barchart.
If im not mistaken there is a string i can enter to pull from the excel spreadsheet field, am i correct?
If not would it be easier to make a little page where the management could enter a number and it directly update the barchart??
Any suggestions will be helpful..ill check this as much as possible

#2 Guest_docseussman_*

Guest_docseussman_*
  • Guests

Posted 27 July 2006 - 03:06 PM

I don't believe that PHP has any native functions for 'simply' reading an Excel file, maybe as a COM or ODBC object, not sure. If if were my problem I would probably approch this situation from another direction like using Excel's ability to save a page as XML data, PHP is readily able to read and parse an XML file.

My 2 cents,
Doc

#3 s10ryan

s10ryan
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 27 July 2006 - 05:53 PM

would that be the easiest thing to do?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users