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.
Excel SpreadSheet to Website
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
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
 |