Excel File download with specific sheet name and file name

See more:

ASP.NET4

Hello friends,

I have created one blank excel file with "Sample1" sheet name and placed in one folder. My requirement is, I have one button and when button is clicked, I need to write some data in excel file and then excel file will be downloaded, this all concept is written in [WebMethod] which is called by jquery ajax method.

When [WebMethod] is called then I copy blank excel file in specific folder and write content into it and then download that excel file, My problem is, I want to download excel file with specific sheet name. Suppose, sample blank excel file sheet name is "Sample1" then downloaded file sheet name should be "Sample1" but when I open downloaded file then sheet name is changed with the file name.

context.Response.Clear();
        context.Response.ClearHeaders();
        context.Response.ClearContent();
        context.Response.ContentType = GetMimeTypeByFileName(System.IO.Path.GetExtension(fileExtension);
        context.Response.AddHeader("Content-Disposition", "attachment; filename=\"" + fileName + "\"");
        context.Response.TransmitFile(completePath);

Thanks
Imrankhan