Export to Excel from ashx file

Question

I am trying to export to excel from an .ashx file called from a jquery event. My data is prepared correctly. but I'm not prompted to save. If I use the asp.net click event, it works perfectly, but from the jquery, the data goes back to the calling jquery event. For reasons that would take way too long to explain, I must use the ashx code. What do I need to do?

context.Response.ClearHeaders();
context.Response.Clear();
context.Response.ClearContent();
string attachment = "attachment; filename='UserRolesPermissions.xls'";
context.Response.AddHeader("content-disposition", attachment);
context.Response.ContentType = "application/vnd.ms-excel";
context.Response.Write(excelData);
context.Response.Flush(); 
context.ApplicationInstance.CompleteRequest();

I've tried various combinations using Flush, End and CompleteRequest. Same results (End errored out).

Thank you.

Possible duplicate of How do I get browser to prompt user to save a file dynamically generated by server? — EdSF
– EdSF, Commented Aug 17, 2018 at 22:08

VDWWD · Accepted Answer · 2018-08-17 21:40:02Z

1

It seems you are missing the content-length header. This could make a difference.

//make sure the data is a byte array
byte[] bin = excelData;

context.Response.ClearHeaders();
context.Response.Clear();
context.Response.Buffer = true;
context.Response.ContentType = "application/vnd.ms-excel";
context.Response.AddHeader("content-disposition", "attachment; filename=\"UserRolesPermissions.xls\"");

//this could help
context.Response.AddHeader("content-length", bin.Length.ToString());
context.Response.OutputStream.Write(bin, 0, bin.Length);

context.Response.Flush();
context.ApplicationInstance.CompleteRequest();

answered Aug 17, 2018 at 21:40

VDWWD

35.7k23 gold badges67 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export to Excel from ashx file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related