Welcome to WebmasterWorld Guest from 54.158.51.150

Forum Moderators: rogerd & travelin cat

Message Too Old, No Replies

Generating Wordpress Content from Excel Tables

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



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!
8:23 pm on Dec 24, 2011 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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.
7:40 pm on Apr 25, 2012 (gmt 0)



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

Featured Threads

Hot Threads This Week

Hot Threads This Month