Save client-side modified excel file to database

[alenak]

Hi everbody,

I have a webform which has iframes and one of iframes rendering excel content that users modify. I want to save modified excel page clicking a button (saving client-side then uploading file is not acceptable way because users have no save permissions) to webserver thus database. How can I do this? Note: this is a local application meaning runs on intranet.

thanks for your replies in advance.

[alenak]

Nobody has any idea? so bad :(

[perhapscwk]

can your webform load a excel file?

[alenak]

a typical browser renders excel file

[JamieHowarth0]

Hi alenak,

If I'm correct, you want people to be able to open an Excel spreadsheet that is rendered in the browser in the Excel-style controls, then edit it and save it back to the database?

In short - this is not possible.

In long - the reason it's not possible is because when you request anything except HTML-related files (CSS, ASP, PHP etc. etc.) the server sends it as a binary stream to the user's machine which is then stored by the operating system as a temporary file in the browser's cache.
So when a user opens the Excel spreadsheet, it's downloaded to their computer, then rendered in the browser, so any changes they make will only be saved on their computer unless they upload the new spreadsheet with their amendments to the server.

I believe that you can save an Excel file as an HTML file which you can then serve, and (providing you give anonymous read/write access on this file) users can then read, modify and save any changes back to the server, but I have never tested this myself so I am making a (very) educated guess.

(I assume/guess) you would do this by going to File > Save As > and in the File types drop-down list select "Web Page (.htm, .html)", then in the options above ensure that the checkbox marked "Add interactivity" is checked, but as I say, nothing more than an educated guess.

Hope this helps.

medicineworker

P.S. I also moved your thread because I felt it was more appropriate in the Windows forum but Windows mods, please feel free to throw it back my direction if you feel the need :-)