blocks|key|161155|text|我不得不做一些小改动才能让它正常工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|161156|首先:将方法更改为post|161157|[AcceptVerbs("POST")]|code-block|syntax|javascript|161158|第二:从使用jQuery+ajax库改为使用隐藏表单，下面是我的服务函数，用于执行隐藏表单并提交它。|161159|exportExcel:+(successCallback)+=>
++++if+$('#hidden-excel-form').length+<+1
++++++++$('<form>').attr(
++++++++++++method:+'POST',
++++++++++++id:+'hidden-excel-form',
++++++++++++action:+'api/tools/exportXls'
++++++++).appendTo('body');

++++$('#hidden-excel-form').bind("submit",+successCallback)
++++$('#hidden-excel-form').submit()|161160|希望有更好的方法来做到这一点，但就目前而言，它正在工作并很好地下载了excel文件。|161161|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I had to make a couple of small changes to get this to work

First: Change the method to a post

<pre><code>[AcceptVerbs("POST")]
</code></pre>

Second: Change from using the jQuery ajax lib to use a hidden form, here's my service function for doing the hidden form and submitting it.

<pre><code>exportExcel: (successCallback) =&gt;
 if $('#hidden-excel-form').length &lt; 1
 $('&lt;form&gt;').attr(
 method: 'POST',
 id: 'hidden-excel-form',
 action: 'api/tools/exportXls'
 ).appendTo('body');

 $('#hidden-excel-form').bind("submit", successCallback)
 $('#hidden-excel-form').submit()
</code></pre>

Hopefully there's a better way to do this but for the time being it's working and downloading the excel file nicely.

blocks|key|379126|text|这将在您单击特定按钮时返回一个文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|379127|+public+FileResult+ExportXls(){
+++++//the+byte+stream+is+the+file+you+want+to+return
+++++return+File(bytes,+"application/msexcel")
+++++}|code-block|syntax|javascript|379128|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This will return a file when you click a particular button

<pre><code> public FileResult ExportXls(){
 //the byte stream is the file you want to return
 return File(bytes, "application/msexcel")
 }
</code></pre>

blocks|key|161222|text|也可以作为HTTP+GET方法使用，但不要使用$ajax，而要使用window.open(url)；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|161223|C#代码：|161224|++++[HttpGet]
++++[Route("report/{scheduleId:int}")]
++++public+HttpResponseMessage+DownloadReport(int+scheduleId)
++++{
++++++++var+reportStream+=+GenerateExcelReport(scheduleId);
++++++++var+result+=+Request.CreateResponse(HttpStatusCode.OK);

++++++++result.Content+=+new+StreamContent(reportStream);
++++++++result.Content.Headers.ContentType+=+new+MediaTypeHeaderValue("application/octet-stream");
++++++++result.Content.Headers.ContentDisposition+=+new+ContentDispositionHeaderValue("attachment")
++++++++{
++++++++++++FileName+=+"Schedule+Report.xlsx"
++++++++};

++++++++return+result;
++++}|code-block|syntax|javascript|161225|JS代码：|161226|downloadScheduleReport:+function+(scheduleId)+{
++++var+url+=+baseUrl+%2B+'api/Tracker/report/'+%2B+scheduleId;
++++window.open(url);
}|161227|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Works also as a HTTP GET method, but don't use $ajax, instead use 
window.open(url);

C# code:

<pre><code> [HttpGet]
 [Route("report/{scheduleId:int}")]
 public HttpResponseMessage DownloadReport(int scheduleId)
 {
 var reportStream = GenerateExcelReport(scheduleId);
 var result = Request.CreateResponse(HttpStatusCode.OK);

 result.Content = new StreamContent(reportStream);
 result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
 result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
 {
 FileName = "Schedule Report.xlsx"
 };

 return result;
 }
</code></pre>

JS code:

<pre><code>downloadScheduleReport: function (scheduleId) {
 var url = baseUrl + 'api/Tracker/report/' + scheduleId;
 window.open(url);
}
</code></pre>

blocks|key|379210|text|我也遇到过同样的问题。通过以下方式解决了问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|379211|window.open(url)|offset|length|style|CODE|379212|entityMap^0|0|0|G|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I experienced the same problem. 
Problem solved with the following:

<code>window.open(url)</code>

blocks|key|161344|text|它会将创建的excel文件存储在系统中的一个文件夹中，一旦发送到浏览器，它将被删除。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|161345|+++++//path+to+store+Excel+file+temporarily
+++++string+tempPathExcelFile+=+AppDomain.CurrentDomain.BaseDirectory+%2B+DateTime.Now.Hour+%2B+DateTime.Now.Minute+%2B
++++++++++++++++++++++++++DateTime.Now.Second+%2B+DateTime.Now.Millisecond+%2B
++++++++++++++++++++++++++"_temp";
++++++++try
++++++++{
++++++++++++//Get+Excel+using++Microsoft.Office.Interop.Excel;
++++++++++++Excel.Workbook+workbook+=+ExportDataSetToExcel();
++++++++++++workbook.SaveAs(tempPathExcelFile,+workbook.FileFormat);
++++++++++++tempPathExcelFile+=+workbook.FullName;
++++++++++++workbook.Close();
++++++++++++byte[]+fileBook+=+File.ReadAllBytes(tempPathExcelFile);
++++++++++++MemoryStream+stream+=+new+MemoryStream();
++++++++++++string+excelBase64String+=+Convert.ToBase64String(fileBook);
++++++++++++StreamWriter+excelWriter+=+new+StreamWriter(stream);
++++++++++++excelWriter.Write(excelBase64String);
++++++++++++excelWriter.Flush();
++++++++++++stream.Position+=+0;
++++++++++++HttpResponseMessage+httpResponseMessage+=+new+HttpResponseMessage();
++++++++++++httpResponseMessage.Content+=+new+StreamContent(stream);
++++++++++++httpResponseMessage.Content.Headers.Add("x-filename",+"ExcelReport.xlsx");
++++++++++++httpResponseMessage.Content.Headers.ContentType+=+new+MediaTypeHeaderValue("application/vnd.ms-excel");
++++++++++++httpResponseMessage.Content.Headers.ContentDisposition+=
++++++++++++++++new+ContentDispositionHeaderValue("attachment");
++++++++++++httpResponseMessage.Content.Headers.ContentDisposition.FileName+=+"ExcelReport.xlsx";
++++++++++++httpResponseMessage.StatusCode+=+HttpStatusCode.OK;
++++++++++++return+httpResponseMessage;

++++++++}
++++++++catch+(Exception+ex)
++++++++{
++++++++++++_logger.ErrorException(errorMessage,+ex);
++++++++++++return+ReturnError(ErrorType.Error,+errorMessage);
++++++++}
++++++++finally
++++++++{
++++++++++++if+(File.Exists(tempPathExcelFile))
++++++++++++{
++++++++++++++++File.Delete(tempPathExcelFile);
++++++++++++}
++++++++}

++++++//Javascript+Code
++++++$.ajax({
++++++++++++++++++++url:++"/api/exportReport",
++++++++++++++++++++type:+'GET',
++++++++++++++++++++headers:+{
++++++++++++++++++++++++Accept:+"application/vnd.ms-excel;+base64",
++++++++++++++++++++},
++++++++++++++++++++success:+function+(data)+{+++
++++++++++++++++++++++++var+uri+=+'data:application/vnd.ms-excel;base64,'+%2B+data;
++++++++++++++++++++++++var+link+=+document.createElement("a");++++
++++++++++++++++++++++++link.href+=+uri;
++++++++++++++++++++++++link.style+=+"visibility:hidden";
++++++++++++++++++++++++link.download+=+"ExcelReport.xlsx";
++++++++++++++++++++++++document.body.appendChild(link);
++++++++++++++++++++++++link.click();
++++++++++++++++++++++++document.body.removeChild(link);++++++++++++++++++++++++
++++++++++++++++++++},
++++++++++++++++++++error:+function+()+{
++++++++++++++++++++++++console.log('error+Occured+while+Downloading+CSV+file.');
++++++++++++++++++++},
++++++++++++++++});+
++++In+the+end+create+an+empty+anchor+tag+at+the+end+of+your+html+file.+<a></a>|code-block|syntax|javascript|161346|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

It will store the excel file created in a folder in the system and once its sent to Browser, it will be deleted .

<pre><code> //path to store Excel file temporarily
 string tempPathExcelFile = AppDomain.CurrentDomain.BaseDirectory + DateTime.Now.Hour + DateTime.Now.Minute +
 DateTime.Now.Second + DateTime.Now.Millisecond +
 "_temp";
 try
 {
 //Get Excel using Microsoft.Office.Interop.Excel;
 Excel.Workbook workbook = ExportDataSetToExcel();
 workbook.SaveAs(tempPathExcelFile, workbook.FileFormat);
 tempPathExcelFile = workbook.FullName;
 workbook.Close();
 byte[] fileBook = File.ReadAllBytes(tempPathExcelFile);
 MemoryStream stream = new MemoryStream();
 string excelBase64String = Convert.ToBase64String(fileBook);
 StreamWriter excelWriter = new StreamWriter(stream);
 excelWriter.Write(excelBase64String);
 excelWriter.Flush();
 stream.Position = 0;
 HttpResponseMessage httpResponseMessage = new HttpResponseMessage();
 httpResponseMessage.Content = new StreamContent(stream);
 httpResponseMessage.Content.Headers.Add("x-filename", "ExcelReport.xlsx");
 httpResponseMessage.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.ms-excel");
 httpResponseMessage.Content.Headers.ContentDisposition =
 new ContentDispositionHeaderValue("attachment");
 httpResponseMessage.Content.Headers.ContentDisposition.FileName = "ExcelReport.xlsx";
 httpResponseMessage.StatusCode = HttpStatusCode.OK;
 return httpResponseMessage;

 }
 catch (Exception ex)
 {
 _logger.ErrorException(errorMessage, ex);
 return ReturnError(ErrorType.Error, errorMessage);
 }
 finally
 {
 if (File.Exists(tempPathExcelFile))
 {
 File.Delete(tempPathExcelFile);
 }
 }

 //Javascript Code
 $.ajax({
 url: "/api/exportReport",
 type: 'GET',
 headers: {
 Accept: "application/vnd.ms-excel; base64",
 },
 success: function (data) { 
 var uri = 'data:application/vnd.ms-excel;base64,' + data;
 var link = document.createElement("a"); 
 link.href = uri;
 link.style = "visibility:hidden";
 link.download = "ExcelReport.xlsx";
 document.body.appendChild(link);
 link.click();
 document.body.removeChild(link); 
 },
 error: function () {
 console.log('error Occured while Downloading CSV file.');
 },
 }); 
 In the end create an empty anchor tag at the end of your html file. &lt;a&gt;&lt;/a&gt;
</code></pre>

blocks|key|379300|text|您可以简单地将类型返回为For.NetCore。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|379301|public+IActionResult+ExportAsExcel()
++++++++{
++++++++++++try
++++++++++++{
++++++++++++++++using+(var+ms+=+new+MemoryStream())
++++++++++++++++{
++++++++++++++++++++var+data+=+ExportData();+//+Note:+This+Should+be+DataTable
++++++++++++++++++++data.ConvertAsStream(ms);
++++++++++++++++++++ms.Position+=+0;
++++++++++++++++++++return+File(ms.ToArray(),+"application/octet-stream",+"ExcelReport.xlsx");
++++++++++++++++}
+++++++++++++++
+++++++++++++++
++++++++++++}
++++++++++++catch+(Exception+e)
++++++++++++{
++++++++++++++++_logger.LogError(e.Message,+e);
++++++++++++++++throw;
++++++++++++}
++++++++}|code-block|syntax|javascript|379302|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For.NetCore you can simply Return type as File.
<pre><code>public IActionResult ExportAsExcel()
 {
 try
 {
 using (var ms = new MemoryStream())
 {
 var data = ExportData(); // Note: This Should be DataTable
 data.ConvertAsStream(ms);
 ms.Position = 0;
 return File(ms.ToArray(), &quot;application/octet-stream&quot;, &quot;ExcelReport.xlsx&quot;);
 }
 
 
 }
 catch (Exception e)
 {
 _logger.LogError(e.Message, e);
 throw;
 }
 }
</code></pre>

I'm trying to send a 9MB <code>.xls</code> file as a response from web api controller method. The user will click a button on the page and this will trigger the download via the browser.

Here's what I've got so far but it doesn't work however it doesn't throw any exceptions either.

<pre><code>[AcceptVerbs("GET")]
public HttpResponseMessage ExportXls()
{
 try
 {
 byte[] excelData = m_toolsService.ExportToExcelFile();

 HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK);
 var stream = new MemoryStream(excelData);
 result.Content = new StreamContent(stream);
 result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
 result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
 {
 FileName = "Data.xls"
 };
 return result;
 }
 catch (Exception ex)
 {
 m_logger.ErrorException("Exception exporting as excel file: ", ex);
 return Request.CreateResponse(HttpStatusCode.InternalServerError);
 }
}
</code></pre>

Here is the coffeescript/javascript jquery ajax call from a button click in the interface.

<pre><code>$.ajax(
 url: route
 dataType: 'json'
 type: 'GET'
 success: successCallback
 error: errorCallback 
 )
</code></pre>

Now that I think about it perhaps the dataType is wrong and shouldn't be json...

Download excel file from page via WebApi call

文件存储

jQuery

我正在尝试发送一个9MB的.xls文件作为web api控制器方法的响应。用户将单击页面上的按钮，这将通过浏览器触发下载。这是我到目前为止得到的，但它不工作，但它也不会抛出任何异常。[AcceptVerbs("GET")]public HttpResponseMessage ExportXls(){    try   ...

问通过WebApi调用从页面下载excel文件
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问通过WebApi调用从页面下载excel文件EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问通过WebApi调用从页面下载excel文件
EN