Forum Moderators: rogerd & travelin cat

Message Too Old, No Replies

Generating Wordpress Content from Excel Tables

         

SusanHouser

3:59 am on Dec 22, 2011 (gmt 0)

10+ Year Member



Hello!

I am currently building a Wordpress website that will have some frequently updated lists of information. For example, the organization has a long membership list that regularly changes. They maintain this list in an Excel chart and will need to regularly transfer the data to a page on the site.

My problem:

1. I need to avoid any retyping to save time discourage errors. Is there some way that the data can automatically be transferred from the Excel file into a Wordpress page? I am hoping that the client can simply update the excel file on the server and not have to touch the page.

2. Rather than displaying the members in one scrolling list, I would like it to automatically divide it into three even columns on the page.

Any help or pointers on a solution for this would be greatly appreciated!

Thank you!

Hoople

8:23 pm on Dec 24, 2011 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Save the Excel file as HTML and then overwrite the old version with the update.

Format the Excel file the way you want the result; the html conversion will loose some formatting niceties keep in mind. This loss is more obvious in non Microsoft browsers.

SusanHouser

7:40 pm on Apr 25, 2012 (gmt 0)

10+ Year Member



I realized that I never did reply to your response. Thank you for the input!