Hello All,

 

I have an excel spreadsheet that i would like to convert to a web page that will retain ALL of its functionality and locked cells or have a web page input into it. i have only HTML experience and need to know how i would do this - any ideas? I have tried the function of saving the spreadsheet in excel as a html file but it loses the drop downs and locked cells etc.

 

Dan

hm... something like Google Spreadsheet? http://www.google.com/googlespreadsheets/try_out.html

Hello All,

 

I have an excel spreadsheet that i would like to convert to a web page that will retain ALL of its functionality and locked cells or have a web page input into it. i have only HTML experience and need to know how i would do this - any ideas? I have tried the function of saving the spreadsheet in excel as a html file but it loses the drop downs and locked cells etc.

 

Dan

Hi, thanks for that but unfortunately not quite what i need. the situation is as follows:

 

there are 20 users who fill identically formatted spreadsheets with similar sales figures. they then email a manager whos spreadsheet has links to theirs that draws data out and shows a top level view. the down side to this is that people have to email their spreadsheets to the manager who saves them into a folder into a folder for it to work. Also users can easily rename the spreadsheet which messes up the links to the manager spreadsheet. The information is never real time either. What i want to do is make these spreadsheets web based in some way so they can live on our intranet. the spreadsheets can remain hidden on the server and all inputs made via a web form. the problem is i have no experience of database driven websites. i was trying to work out if a can use what have already and just make some sort of web form to interact and a page to display data.

 

Dan

Hi Dan,

 

this is quite a big project, from the way that you describe, and would need someone with good experience in PHP, MySQL, and interactive useful JavaScript to make it work. Furthermore this project might take up to 40 hours to complete, which can come to quite a hefty sum.

 

You may be able to find a pre-written script there if you google it hard enough, but if you can't find one, then you need to convince your boss either of these:

1 - it isn't needed

2 - it really is needed... so much that your budget can grow by £600+

 

The interim solution to all this, would be to create a little upload form with a login box, so that the user can upload his work to the right folder, with the right filename. THis would be a much smaller solution (5 hours ~£100), and less "tidy" and definitely less cool, but if your boss/client insists on a solution other than "not to bother", then this might be the way forward.

 

Hope this helps, and don't be afraid to pm me.