Go Back   CodingForums.com > :: Server side development > PHP

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 02-21-2012, 08:44 PM   PM User | #1
zinch33
New Coder

 
Join Date: Feb 2012
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
zinch33 is an unknown quantity at this point
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?
zinch33 is offline   Reply With Quote
Old 02-21-2012, 10:32 PM   PM User | #2
mlseim
Master Coder

 
mlseim's Avatar
 
Join Date: Jun 2003
Location: Cottage Grove, Minnesota
Posts: 9,046
Thanks: 8
Thanked 1,029 Times in 1,020 Posts
mlseim has a spectacular aura aboutmlseim has a spectacular aura aboutmlseim has a spectacular aura about
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?
mlseim is offline   Reply With Quote
Old 02-21-2012, 11:08 PM   PM User | #3
zinch33
New Coder

 
Join Date: Feb 2012
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
zinch33 is an unknown quantity at this point
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.
zinch33 is offline   Reply With Quote
Old 02-21-2012, 11:16 PM   PM User | #4
mlseim
Master Coder

 
mlseim's Avatar
 
Join Date: Jun 2003
Location: Cottage Grove, Minnesota
Posts: 9,046
Thanks: 8
Thanked 1,029 Times in 1,020 Posts
mlseim has a spectacular aura aboutmlseim has a spectacular aura aboutmlseim has a spectacular aura about
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.
mlseim is offline   Reply With Quote
Old 02-21-2012, 11:37 PM   PM User | #5
litebearer
Regular Coder

 
Join Date: Apr 2004
Posts: 287
Thanks: 0
Thanked 21 Times in 21 Posts
litebearer is on a distinguished road
http://devzone.zend.com/27/reading-a...eets-with-php/
litebearer is offline   Reply With Quote
Users who have thanked litebearer for this post:
zinch33 (02-21-2012)
Old 02-21-2012, 11:41 PM   PM User | #6
zinch33
New Coder

 
Join Date: Feb 2012
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
zinch33 is an unknown quantity at this point
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.
zinch33 is offline   Reply With Quote
Old 02-21-2012, 11:49 PM   PM User | #7
zinch33
New Coder

 
Join Date: Feb 2012
Posts: 17
Thanks: 2
Thanked 0 Times in 0 Posts
zinch33 is an unknown quantity at this point
Quote:
Originally Posted by litebearer View Post
Thanks, I'll check this out. Looks like it may help with what I'm looking for.
zinch33 is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 06:10 AM.


Advertisement
Log in to turn off these ads.