FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Excel SpreadSheet to Website





NjRocket
Hi, i'm working on some things that are going to be down in excel on a spread sheet. Well heres the problem, im going to sort them all by one category. Is there an easier way to put it on my website than manually editing it on mywebsite? I want it to look like a table also in the middle of my site, not a download file or anything like that. I'm curious, would save ALOT of time.
biedr0na666
yep, there is a way to do it.

you could just go 'save the file as hweb page under FILE menu in Excel :]
this would generate a big html file with lots and lots of useless tags...

there's diffrent way of course.
save the file as text and then write a simple script in PHP that would read the file and parse it into lines (function 'file(file_path)') then 'foreach' line do process the line (e.g. replace spaces with </td><td> and so on). Then save the file.

you can find many useful php string functions here:
http://pl2.php.net/manual/en/ref.strings.php

i hope that helped a bit

EDIT: hey NjRocket:) I didn't see that's you again, until now;D
Related topics
Working with Excel, PHP & MySQL. Any Ideas
Excel macros
Nyxem virus set to strike tonight
online spreadsheet
What are your Firefox extensions
Howto automate your Browsing
Sleep less to get more out of life?
Who in here trade in the stock Market?
Design question on database
Saving excel from email attachment (HELP)
VBA - Best way to learn?
Web form to save HTML table as spreadsheet
How to reverse rows in Excel?
How to create Realistic Action-Based New Year's Resolutions
Reply to topic    Frihost Forum Index -> Webmaster and Internet -> Design Tips

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.