Excel data from a user to a web page

Discuss general web development questions. Help others and get help from others.

Moderator: kfury77

Excel data from a user to a web page

Postby notuo » Fri Sep 25, 2009 1:17 am

Hi all.

Is good to return here after a while and the first thing I do is to ask for help. Shame on me...

But I need to ask you guys for this. I have a customer that handles its own excel data (30 rows at most by 7 fixed cols)

What he wants is to publish (himself) his data to his web site using the simplest method available.

He doesn't know anything about html, php or technical things.

Any idea around? any advise to research?

Thanks in advance and I promise I will contribute here as in the past.

Regards to all and thanks in advance,

Angel
User avatar
notuo
 
Posts: 258
Joined: Sat Jul 09, 2005 8:07 pm
Location: Tlalpan, Mexico City, Mexico

Re: Excel data from a user to a web page

Postby MikeyB » Fri Sep 25, 2009 10:23 am

Hi,

Well the simplest way in Excel is to do File -> Save as Web Page
This will save it as a complete html file you can then upload to your webspace.
User avatar
MikeyB
Top Contributor
 
Posts: 511
Joined: Fri Jun 09, 2006 10:38 am
Location: UK

Re: Excel data from a user to a web page

Postby notuo » Fri Sep 25, 2009 3:53 pm

Thanks MikeyB but I am afraid I didn't explain myself well.

There are 2 issues here.

1) He wants to be independent uploading new versions of this
2) The resulting table is part of a design. Now is a table and now with new requirements I have to figure out a better way to display the table. Here you can see the table http://www.plasticosreich.com/en/purchases.php

I just tested your recommendation and I found some issues.
1) Excel as expected bloated the html with a bunch of unnecessary code
2) Produces a whole html not just the table.

I am going to search for 2 options:

1) Excel to table
2) Save the excel to cvs, upload this file, has the code in the page to read the cvs and produce the table.

Any other idea is welcome.

Thanks again
User avatar
notuo
 
Posts: 258
Joined: Sat Jul 09, 2005 8:07 pm
Location: Tlalpan, Mexico City, Mexico

Re: Excel data from a user to a web page

Postby syrupcore » Tue Sep 29, 2009 8:50 pm

some ideas...

tinyMCE and other editors have a table editing mode. If you can set them up with that, they could just go and update the data cell by cell.

if they can export to tab-delimited format, you could read that into your php page directly. http://www.dreamincode.net/forums/showtopic10132.htm

adobe sells a certain very overpriced HTML editor that lots of people still use for some reason, ahem, and it has one very nice feature - copy from excel and paste into its design view. creates a nice clean HTML table that your client could go and then paste into the html document.

you might also be able to have them upload the crappy "save as html" file from excel and then use PHP to go and extract that part that you want and display it in the middle of your design. might even be able to get away with doing it by line number since presumably excel will always output the same number of lines.


will
User avatar
syrupcore
Top Contributor
 
Posts: 917
Joined: Thu Jul 21, 2005 12:58 am
Location: Portland, Oregon, usa

Re: Excel data from a user to a web page

Postby notuo » Thu Oct 01, 2009 1:47 am

Hi Will.

Thanks for your comments.

I'll check that dreamingcode page, fits better my case. I want to share also this in case anyone is interested:

http://www.codewalkers.com/c/a/File-Manipulation-Code/Simple-CSV-to-HTML-Table/

that has a newest version:

http://forums.devnetwork.net/viewtopic.php?f=1&t=91610&start=0&st=0&sk=t&sd=a

Regards,

Angel
User avatar
notuo
 
Posts: 258
Joined: Sat Jul 09, 2005 8:07 pm
Location: Tlalpan, Mexico City, Mexico


Return to Web Developer Talk

Who is online

Users browsing this forum: No registered users and 16 guests

cron