Wordpress and Excel, basically is it possible?

 

As a client of mine has thousands of cell's of information in an excel document and i need to know if there a way to spit out the information in wordpress or just generally into a webpage. (As once it's in the webpage I could style it using CSS).

 

Can you do it? Is there a way to do it?

 

Owen

Edited June 7, 201214 yr by OwenONeill

There are plenty of site/tools out there that will do it if you just want it as a one-off. Just search for "Excel to HTML table".

 

If you're looking to do it on more of a long term basis, it would be easier to convert the spreadsheet to a CSV file. Then either import that into a database, or use something like fopen/fgetcsv and a bit of PHP to open the file and convert into HTML.

There are plenty of site/tools out there that will do it if you just want it as a one-off. Just search for "Excel to HTML table".

 

If you're looking to do it on more of a long term basis, it would be easier to convert the spreadsheet to a CSV file. Then either import that into a database, or use something like fopen/fgetcsv and a bit of PHP to open the file and convert into HTML.

 

That sounds pretty good! So basically I could use the link below and spit it into a Wordpress loop somehow?

 

http://www.homeandlearn.co.uk/php/php10p6.html

 

That would seriously save me a lot of time.. and I could actually just drop the CSV's into a folder...

 

(may not be 100% correct, but want a rough idea)..

Edited June 8, 201214 yr by OwenONeill

Yup, that's the kind of thing I was talking about.

 

However, a lot of webhosts disable fopen() on their servers as it's consider to be a security risk if you don't use it properly so you may have to go down the database route.

Yup, that's the kind of thing I was talking about.

 

However, a lot of webhosts disable fopen() on their servers as it's consider to be a security risk if you don't use it properly so you may have to go down the database route.

 

 

Cheers Roothost - Appreciate it, you have definitely put me on the right track; I suppose as I am using Wordpress, I could develop a custom post type and display each row in the csv as a separate post - using something like this? http://wordpress.org/extend/plugins/csv-importer/other_notes/

 

Do you think that would work, using a loop and then having it spit out the information and stop when no more row's are seen in the file?..