Brandi Steell

Brandi Steell

  • NA
  • 8
  • 479

export excel data and edit it, save it again as a file

Nov 25 2018 12:05 PM
with ASP.NET MVC 
 
is it possible to export an excel file from its path in the database then edit its content like some sort of edit form and import it back as an excel file path. is there like faster way or a method i can use? or is it even possible to trick the users into thinking that they are editing a live-edit form but its just and excel form? the reason why i need this, is because iwant say for example a faculty member to evaluate students. but the evaluation form fields are too much to store in the database and the fields and the evaluation criteria may be changed in the future. what would you suggests me doing at this case?
 

what i did so far is ask faculty members to upload their evaluations as an excel sheet. and then extract the final grade. and store only the final grade in the database. however, this is not what my client wants.