Topic awaiting preservation: excel > browser (Page 1 of 1)

do anyone know of a very simple solution to display an excel work sheet in a layer without saving the excel sheet as a webpage. i.e The website owner will upload a xls file to the webserver every week and the webpage will import all the data and display it in a similar layout upon call. I have searched for answer but all solutions seem to involve technologies such as POI /Java ect.

FatRod: That sounds like a rather messy way of doing things but........

I would imagine that ASP has some ways o dealing with this kind of thing. That said I suspect most server side languages could probably process the spreadsheet but it would be better if it was exported as something sim ple like CSV.

___________________
Emps

FAQs: Emperor

I have found a solution (and it was ASP) but also discovered that this would apparently be a very bad idea.

"ASP is meant to handle multiple users, Excel is not so you will experience problems if you put this on a server that handles multiple users"

do you think making the XL file read only would make a difference?

Well, first of all - what server side languages do you have available on your server, and which are you familiar with?

Either way, you would most likely want to export the file as a CSV file first, as Emperor suggested. Makes things much easier to work with.

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.

I'd personally get him to export the data as a CVS file then use PHP's explode function to break the data down and interpret into a table.

That way multiple users can view it at the same time with no worries. So long as he keeps the format of the spreadsheet constant, you will not have a problem with it.

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.

Hmmm...you're dead right there InI...I just think that IIS is so much the work of the devil that I continue to deny t's existance at every possible opportunity...

cheers chaps.