The Following Function downloads the Excel .
It accepts the following paramete :
fileName : It contains the path with FileName . I.e : "D:\MyExcel.exe".
Code :
It accepts the following paramete :
fileName : It contains the path with FileName . I.e : "D:\MyExcel.exe".
Code :
/// <summary> /// Download Excel template with some existing data /// </summary> /// <param name="fileName"></param> private void DownloadExcel(string fileName) { try { FileInfo file = new FileInfo(fileName); if (file.Exists) { // Clear the content of the response Response.ClearContent(); Response.Clear(); // add the header that specifies the default filename for the Download/SaveAs dialog Response.AddHeader("Content-Disposition", "attachment; filename=LMSUsers.xls"); // add the header that specifies the file size, so that the browser can show the download progress Response.AddHeader("Content-Length", file.Length.ToString()); // specify that the response is a stream that cannot be read by the client and must be downloaded Response.ContentType = "application/vnd.ms-excel"; // send the file stream to the client Response.WriteFile(file.FullName); Response.BufferOutput = true; Response.Flush(); Response.Close(); //Delete the file if Required file.Delete(); } } catch (Exception ex) { throw new Exception(ex.InnerException.Message); } }
No comments:
Post a Comment