content management via Excel possible???

[pstar99]

The idea:

an authorized web user (novice) uploads an Excel spreadsheet via FTP to a website.

The spreadsheet contains 9 rows and 5 columns, which will look something like this:

12345 | sky | blue | sunny | happy |

-------------------------------------------

54321 | water | green | cold | sad |

-------------------------------------------

etc ...

 

The script I'm looking for would show the first 3 of the 9 rows at the same time and rotate to the next 3 on refresh and so on.

 

The output of the script would look something like this:

 

<div><p><a href="http://www.xyz.com/12345.html>;<img src="http://www.xyz.com/12345.jpg" /></a><br />

<strong>sky</strong><br />blue<br />sunny<br />happy</p><br />

<p><a href="http://www.xyz.com/12345.html">Details</a></p></div><br />

<div><p><a href="http://www.xyz.com/54321.html>;<img src="http://www.xyz.com/54321.jpg" /></a><br />

<strong>water</strong><br />green<br />cold<br />sad</p><br />

<p><a href="http://www.xyz.com/54321.html">Details</a></p></div>

 

etc...

 

the script structure would always be the same but the values of each div would change based on the row values of the spreadsheet.

Can this be done?

 

[meltingpoint]

I am not sure about a program that will- on the server side, take an excel spread sheet and extract the data to a csv file to then be pulled into the php page for viewing.

 

If they can- export the excel spreadsheet as a csv file and upload that to the server.  Then when you call the php page - it will open the file and extract the data so that you can do what ever with it. 

 

My limited thoughts on this...........

[MatthewJ]

http://phpexcel.codeplex.com/