Sign up for Office 365
Learn more about Office 365
I have a excel ribbon bar addin that creates a spreadsheet based on a few fields in a dialog. It's like a search screen that selects a number of rows which are then loaded in to the spreadsheet. This is of course an addin that needs to be installed to our LAN users. We would like to offer this capability to our public users. We could provide a web application that provides functionality of a similar nature, but we don't want to store the users input to fields in our database. We don't think users will want us access to their data/additions. We would also like to allow them to access the spreadsheet where ever they are, so a cookie or local storage option would not work. Cloud storage seems like a good choice, but how would we store the document in the cloud but still allow the user access to the file. So some kind of limited shared cloud folder, where we could create them a document but not be able to retrieve it after they have edited it. Any suggestions would be welcome.
This is Cody with Microsoft SharePoint Online Support. Thank you for your post.
I regret to inform you that the public website would not be able to create a document that public users could then access again later. Any type of document that was created through a spreadsheet would be saved on your account and then become internal, unless you shared it out publicly later. This would provide the document to anyone, though.
You may be able to create some sort of HTML/Java custom-coded application for this functionality. Since the document needs to not be saved on the account, and needs to be publicly available to the anonymous user, a sandboxed solution would not work. This situation would likely need a HTML/Java application that helps create the spreadsheet, and then sends it to the customer without saving it to the site itself. Please keep in mind that custom-coding is done at your own risk.
I apologize for not being able to provide more specific instructions.
Microsoft SharePoint Online Support