Display Excel in webpage with data from SQL server and save

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;
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Cassie Mod9y ago
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;
       }
0