Display Excel in webpage with data from SQL server and save

Question

Display Excel in webpage with data from SQL server with formulas and other stuff. After making some changes i can save that excel back to server. Any Spreadsheet JS or something. Actually i want to create a website for Online Excel Test in which i want to show users a excel with data stored in SQl Server and user will perform some operations in that excel based on question and finally i will save that excel back to sql for examine that excel later. Tried different api but not able to accomplish this task???

Cassie Mod · Answer

u could use this as an example  it is what i used to show the excel in the browser [HttpGet] [ActionName( CDR )] public ActionResult DownloadCdr(string id /* invoice number */ ) { // Create request var invoicerequest = new GetInvoiceRequest { InvoiceNumber = id }; // Get response InvoiceDetails invoice; using (var client = new InvoiceServiceClient()) { var invoiceresponse = client.GetInvoice(invoicerequest); var errorCode = invoiceresponse.ErrorCode; var errorMessage = invoiceresponse.ErrorMessage; invoice = invoiceresponse.Invoice; } // Check if invoice is not null if (invoice != null) { byte[] cdrFile; using (var billingclient = new BillingServiceClient()) { var exportrequest = new ExportCDRsToExcelRequest {InvoiceNumber = id}; var exportresponse = billingclient.ExportCDRsToExcelFile(exportrequest); cdrFile = exportresponse.FileData; } //Check if cdrFile is not null if (cdrFile == null) return HttpNotFound( Gespreksgegevens niet gevonden. ); var fileName = HttpUtility.UrlEncode($ { cdr }_{id}.xlsx ); var contentDisposition = new System.Net.Mime.ContentDisposition { FileName = fileName Inline = true // false = always prompt the user for downloading true = browser tries to show the file inline }; Response.AppendHeader( Content-Disposition  contentDisposition.ToString()); //return file return File(cdrFile application/vnd.openxmlformats-officedocument.spreadsheetml.sheet ); } return null; }