Saving user data entered into an excel form embedded on a website Options

[Rob161]

Hi,

I have a website with an embedded excel spreadsheet (from onedrive using the javascript option) which users can interact with. My goal is to give the users the ability to save what they have entered so far so they can recommence at a later time. Also I would only allow this to users who have signed up.

I hope someone can help.

Thanks in advance!

[Christian J]

I have a website with an embedded excel spreadsheet (from onedrive using the javascript option) which users can interact with. My goal is to give the users the ability to save what they have entered so far so they can recommence at a later time.

They could save it in their own browser (similar to a cookie) with javascript webstorage/localstorage.

However, many users will not be able to view Excel files at all. A more reliable solution might be to let a server-side script like PHP read the Excel file and display its content as a normal HTML web page (e.g. as a form). Alas I don't know any details.

Also I would only allow this to users who have signed up.

That part needs a server-side solution, probably also a database to store all usernames and passwords.

But if it's a just a small number of users (and you can handle their sign-up processes manually) you might use HTTP authentication instead, which is much simpler.