Click here to Skip to main content
15,742,619 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I made an ASP.Net website application with an embedded excel spreadsheet. I am trying to update chosen cells in the embedded spreadsheet with values calculated by the application. I am somewhat familiar with writing data with EPPlus, but how would I write data if the spreadsheet is on a webpage?

I embedded the excel spreadsheet from onedrive like this:

<iframe width="700" height="346" frameborder="0" scrolling="no" src=""></iframe>

What I have tried:

Opening the excel spreadsheet on my computer worked in testing, but since I am deploying the site to users it is best to open spreadsheet in web browser
Updated 16-Oct-18 8:04am

1 solution

You can't edit an embedded Excel Online workbook, but people with the right permission may be able to open the embedded workbook in Excel, where they can edit the data.
Share this answer
Member 13396929 16-Oct-18 14:20pm    
In that case, instead of embedding, could i just store the excel spreadsheet in the website and have the user open it?
Kornfeld Eliyahu Peter 16-Oct-18 14:25pm    
Yes, but in that case all the instances (onedrive, the website and the enduser) will be disconnected... which means that changes to one will not reflect on others...
Member 13396929 16-Oct-18 14:30pm    
okay, so even if I save the c# value in an ASP.Net HiddenField i can't write it to Excel? And, I am trying to write to Excel, but the changes a user makes are not meant tot be saved after closing
Kornfeld Eliyahu Peter 16-Oct-18 15:01pm    
If changes are not meant to be save, why enable changes in the first place?
MadMyche 16-Oct-18 15:14pm    
Perfect. Have them download a copy of the Excel file so that the master doesn't get changed.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900