Use an Excel file generated by Ajax and click "Submit" to generate an excel file by ajax.

Use an Excel file generated by Ajax and click "Submit" to generate an excel file by ajax.

I haven't published any articles for a long time. Today I will share my article on how to use ASP. net mvc uses the method of generating files under Ajax. The following is just a personal experience: everyone should know that in ASP. net mvc, if the controller is used after Ajax expires, a json object can be returned, but the object cannot be directly returned (unless the interface is refreshed, so if you want to use Ajax to generate a file and download it, you only need to save the generated file to the server first, then, the file path is returned in JSON format before it can be written down. Of course, it is stored in temporary mode, therefore, after the download, the corresponding file needs to be deleted immediately. The following is an example of how to generate an Excel file by using an animation (I will omit the specific step for generating an Excel file, which is not the focus of this article): 1. create an Action to generate an Excel file

[HttpPost] public JsonResult ExportExcel () {DataTable dt = DataService. getData (); var fileName = "Excel _" + DateTime. now. toString ("yyyyMMddHHmm") + ". xls "; // Save the generated file to the duration of the server. string fullPath = Path. combine (Server. mapPath ("~ /Temp "), fileName); using (var exportData = new MemoryStream () {// how to generate an Excel file, I am using NPOI Utility for Excel operations here. writeDataTableToExcel (dt ,". xls ", exportData); FileStream file = new FileStream (fullPath, FileMode. create, FileAccess. write); exportData. writeTo (file); file. close ();} var errorMessage = "you can return the errors in here! "; // Return the generated file name return Json (new {fileName = fileName, errorMessage = ""});}

2. Create the Action used by the producer

[HttpGet] [DeleteFileAttribute] // Action Filter. After the Download is complete, the file is automatically deleted. After the Download, the public ActionResult Download (string file) is obtained) {// The file string fullPath = Path corresponding to the file under the file category when the server crashes. combine (Server. mapPath ("~ /Temp "), file); // return the object, which uses Excel, so the file header uses" application/vnd. ms-excel "return File (fullPath," application/vnd. ms-excel ", file );}

3. to automatically delete files after the download, create an Action Filter.

Public class DeleteFileAttribute: ActionFilterAttribute {public override void OnResultExecuted (ResultExecutedContext filterContext) {filterContext. httpContext. response. flush (); // convert the filter context into a file for specific operations and extract the path string filePath = (filterContext. result as FilePathResult ). fileName; // after a file path exists, you can directly delete the related file System. IO. file. delete (filePath );}}

4. Add the Ajax Token Generation in the previous example:

// Here I use blockUI for loading... $. blockUI ({message: '5. Complete!