Embed Excel File - Separate Member Access

Ask the community
, ,
1

Hi everyone,

I am trying to create a membership/subscription website where I can allow a monthly fee for members to access an Excel file that I have embedded into one of my pages. I have successfully uploaded the file to OneDrive, embedded the file onto a webpage, and added a member’s login to my site. The problem I’m running into is that I want each user to have their own file but do not want to have to upload one specifically for them. I just want them to be able to access the file and have the relevant tables empty when they open it each time. I do not want them to collaborate or to see each other’s data as it is unique and sensitive to each of them individually. But I want them all to access the same file and keep it updated. I don’t want them to be able to download the Excel file either. Right now, they purchase a digital download of the Excel file from my site but I have to send out updates to the file as needed.

Please help?!

2

I have no experience with Excel, but I do with Google Sheets. In that case, Google offers an API to do the following:

  • make a copy of a Master Sheet and Save it under a different name
  • get that file name and save it, so you know which sheet to open next time

I hope/assume that Excel has something similar. But I have to say that this has got very little to do with Wix, apart from wix-fetch, to call the API.

3

Yeah, google sheets doesn’t support pivotcharts. Maybe I’d have more luck on an Excel forum. I was putting it here more in regards to members and having certain permissions to certain files