• I am self-taught, and have a soccer team website ()>. I would like to be able to populate individual players’ statistics/bios for each player on the “statistics” page AND make it easily updatable. In a perfect world, I would set up a template that has a layout like this:

    but which is populated from data stored in an excel spreadsheet like this:

    My excel spreadsheet includes formulas, so comprehensively updating it each week only takes a few keystrokes. Thus, if possible, I’d rather not have to convert my excel spreadsheet to HTML. I want seamless, 1- or 2-step updating.

    I am a real novice with .php, so I was hoping that there was a plug-in that would help me do this easily. A video tutorial would be a bonus. I’ll spend the time to learn if this is doable.

    Any pointers/advice would be appreciated! If what I’m trying to do is unnecessarily complicated or the wrong way to do it, please let me know.

    I just added the”Custom Fields” plug-in, but did not want to learn how to use it if my end result wouldn’t pull from excel. Is that the right tool? Is there something even better?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter FuryFC

    (@furyfc)

    (re-posting because first post didn’t include my links)

    I am self-taught, and have a soccer team website (<a href="http://www.furyfc.com/blog/"></a>I would like to be able to populate individual players’ statistics/bios for each player on the “statistics” page AND make it easily updatable. In a perfect world, I would set up a template that has a layout like this:

    <a href="http://furyfc.com/blog/wp-content/uploads/2013/08/bio_layout.jpg"></a>

    but which is populated from data stored in an excel spreadsheet like this:

    <a href="http://furyfc.com/blog/wp-content/uploads/2013/08/Statistics-2013-14.csv"></a>

    My excel spreadsheet includes formulas, so comprehensively updating it each week only takes a few keystrokes. Thus, if possible, I’d rather not have to convert my excel spreadsheet to HTML. I want seamless, 1- or 2-step updating.

    I am a real novice with .php, so I was hoping that there was a plug-in that would help me do this easily. A video tutorial would be a bonus. I’ll spend the time to learn if this is doable.

    Any pointers/advice would be appreciated! If what I’m trying to do is unnecessarily complicated or the wrong way to do it, please let me know.

    I just added the”Custom Fields” plug-in, but did not want to learn how to use it if my end result wouldn’t pull from excel. Is that the right tool? Is there something even better?

    I’m not sure there is a plugin that will do that – I’ve seen other threads asking for the same sort of thing. You might look at TablePress or http://wordpress.org/plugins/groupdocs-viewer/

    Thread Starter FuryFC

    (@furyfc)

    Thanks. I saw the old threads, too.

    I did make a back end that will do this from xml, but I want something that’s more seamless directly from Excel. TablePress and Custom Fields had me thinking about this again. Tablepress will take an excel csv file and show the data. I want to do that, but the additional step is having a custom layout (i.e., image holders and text boxes, etc.) that are populated, rather than just a table being populated.

    I suppose that what I am trying to do is also similar to e-commerce sites, where the individual player would be like the “purchase item” and his stats would be like the product description, pricing, specs, etc. If there’s an e-commerce site that allows for updating through a freestanding spreadsheet (like Tablepress uses excel) rather than making me use php, mySQL, and other things in which I’m not proficient, then that’d be great. I’m an attorney who just does this for fun at night, so I haven’t had the free time to learn php or how to use mySQL.

    Thread Starter FuryFC

    (@furyfc)

    I haven’t figured it out completely yet, but it looks like WP Ultimate CSV Importer Plugin might do it.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Display Dynamic Content Using Excel?’ is closed to new replies.