homepage Welcome to WebmasterWorld Guest from 54.197.94.241
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / WordPress
Forum Library, Charter, Moderators: lorax & rogerd

WordPress Forum

    
Generating Wordpress Content from Excel Tables
SusanHouser




msg:4400379
 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!

 

Hoople




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

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




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

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / WordPress
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved