Editing server-side Excel s/sheet in ASP.Net 2.0 Page - how?
-
Hi all, I have had what appears to be a very simple request from one of my clients - but am not sure how (or if) this can be done. Basically, they need to be able to let about 6-10 people access and edit an Excel 2003 spreadsheet from anywhere (ie: they could be inside or outside the corporate intranet) and my idea was to allow them to do it through an ASP.Net 2 web page. This means the s/sheet would always reside on the server but could only be edited by one person at a time (which is what the client wants - if it's open for edit all other users will be told the s/sheet is not available - or perhaps they can just view it but not save it.) So how do I go about this using VS2005 and ASP.Net 2? Is it just a matter of having an tag in the HTML or is there a better, easier or more advance way to do it? I've googled quite a bit for this and found lots of pages about importing or exporting Excel data but I want to edit & save the s/sheet in place and I can't find anything about that. TIA for suggestions or feedback. Mike
-
Hi all, I have had what appears to be a very simple request from one of my clients - but am not sure how (or if) this can be done. Basically, they need to be able to let about 6-10 people access and edit an Excel 2003 spreadsheet from anywhere (ie: they could be inside or outside the corporate intranet) and my idea was to allow them to do it through an ASP.Net 2 web page. This means the s/sheet would always reside on the server but could only be edited by one person at a time (which is what the client wants - if it's open for edit all other users will be told the s/sheet is not available - or perhaps they can just view it but not save it.) So how do I go about this using VS2005 and ASP.Net 2? Is it just a matter of having an tag in the HTML or is there a better, easier or more advance way to do it? I've googled quite a bit for this and found lots of pages about importing or exporting Excel data but I want to edit & save the s/sheet in place and I can't find anything about that. TIA for suggestions or feedback. Mike
IMHO, you might want to check out a couple of things: + Use Webdav to manage/edit the files. + Show the file contents at the client side in the Excel-like display, here you can might want to look for some custom grid controls supporting Excel-like style, then the client can edit in the web page and finally submit the changes to the server. + You can allow the user to open the Excel file on their box with the Excel application, then you can use an Excel add-in to capture the Save action to send the edited file to the server.