Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    New Coder
    Join Date
    Feb 2012
    Posts
    17
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Displaying Excel Data in a Webpage

    I'm trying to figure out the best way to approach this.

    I have a protected section on a website for employees. My client wants to add the employee schedule. She keeps this information in an Excel file. She wants to be able to just upload the excel file and have the information display. There will be many cells with data. She will be updating this file and uploading it daily.

    I could have her save the excel file as html before uploading, but I'm not sure if that would display correctly on all platforms.

    What's the best and most efficient way to do this?

  • #2
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,471
    Thanks
    8
    Thanked 1,085 Times in 1,076 Posts
    Save the file as a .csv (comma separated variable) file and upload that.

    PHP can open the .csv file and do whatever you want with it.

    Is there a reason she uses Excel?
    Maybe there's a better way?

  • #3
    New Coder
    Join Date
    Feb 2012
    Posts
    17
    Thanks
    2
    Thanked 0 Times in 0 Posts
    She's in charge of the schedule for the employees and I think Excel is her program of choice for creating it.

    She wants the schedule to be added to the website with minimal effort on her part, since there are hundreds of employees and she needs to update this daily.

    I got the impression she has limited computer knowledge, so it can't be too complicated. She just wants the scheduled displayed. Nothing fancy at all.

    I'll check out the csv route and see if that is something that might work.

  • #4
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,471
    Thanks
    8
    Thanked 1,085 Times in 1,076 Posts
    Find out if Excel can upload a CSV copy of the sheet automatically using FTP.

    With hundreds of employees, I would expect they would be running a
    professional personnel management system of some kind. Hundreds of
    employees implies a larger company than just a mom and pop shop.

    Even if they hired a programmer to create an exceptional custom system,
    they can't afford to do that? No offense to you. I just think they could
    afford a system that is above something a non-professional programmer would
    do (like myself ... a guy with a PC on the kitchen table). Anything they
    purchase is a business tax writeoff.

  • #5
    Regular Coder
    Join Date
    Apr 2004
    Posts
    298
    Thanks
    0
    Thanked 23 Times in 23 Posts

  • Users who have thanked litebearer for this post:

    zinch33 (02-21-2012)

  • #6
    New Coder
    Join Date
    Feb 2012
    Posts
    17
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I'll have to see if they are running something like that.

    She asked me because I've done a couple websites for them. I'm a web designer not developer, so I do have limited knowledge in php coding. They are a company that does contract work, so they have many employees that are not full time, so there are various schedules.

    She originally just wanted a password protected document on the site. We've migrated to having an employee login section with the schedule.

  • #7
    New Coder
    Join Date
    Feb 2012
    Posts
    17
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks, I'll check this out. Looks like it may help with what I'm looking for.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •