Blumentals Software Community

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

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.

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

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

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