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