putting the results of a spreadsheet onto a web page

Stephen_Leader

HELP!!! I am going nuts. I am trying to put the results of an Excel page onto a web page. The Excel data will be updated once a week into its folder and the web page calls whatever data is stored in the folder. I don't want to rewrite the page every time.

Can anyone help a php dunce.

cschotch

Why do you need php for this
In Excel go to File-> Save as Webpage.....
This should work I have done it before...
Or do you want it done automatically each time it is done updating without you ever touching it?

matto

I found this solution:

if the excel document is saved as ".csv" (comma-separated values), excel will automatically separate records with line breaks (good for reading it using the file function), and field-separate within the records with tabs. Still, it will be easily-processible plain text.

I suppose you have a customer who wants to ftp the spreadsheet to the web server and your script will have to update the database or whatever frequently without further need for editing.

have the customer save it as .csv

then your script can do

$thewholefile = file("bla.csv");

foreach($thewholefile as $record)
{
  $fields = explode("\t", trim($record));

// do something with $field[0], $field[1] etc. ... perhaps display it as a html-formatted table, or write it to a database ...
}

Stephen_Leader

Thanks guys,
Yes, the idea is that I simply replace the old Excel file with the new one and the php loads the file (which ever one is there) automatically.

Matto - I tried your script. However, I placed it in the web page and viewed it in Namo 5 and it prints the script to screen and doesn't load the data.

I tried putting the script at the top and also where I want the data to be placed with the same result. Remember I told you I was a php dunce. What am I doing wrong?