Create an excel file in ashx from byte[] array for client download

Question

I'm trying to create an Excel file from a byte[] array after reading the data from a DataTable using a DataTableReader, all this in a ashx file. But it's just not working. Here I post some code:

DataTableReader RS = dt.CreateDataReader();
byte[] byteArray = GetData(RS);

context.Response.ContentType = "application/ms-excel";
context.Response.Clear();

//  context.Response.Charset = "";
try
{
    context.Response.BinaryWrite(byteArray);
    context.Response.OutputStream.Write(byteArray, 0, byteArray.Length);
    context.Response.BufferOutput = true;
    context.Response.Flush();
 }
 catch (Exception ex)
 {
    SendMail(ex.Message.ToString());
 }

It throws the following exception:

context.Response.SubStatusCode threw an exception of type System.PlatformNotSupportedException. {"This operation requires IIS integrated pipeline mode."} ashx

I know that if I use the headers need to have IIS7 or Framework 3+.

Any help would be appreciated!!

score 0 · Answer 1 · answered Oct 19 '12 at 16:59

You set the Response ContentType and then Clear the Response. Then you write the response two times, that's odd too. I would change that, and I would also try calling End instead of Flush.

The minimun amount of code to get it working would be something like:

...
    DataTableReader RS = dt.CreateDataReader();             
    byte[] byteArray = GetData(RS);             

    try   
    {
        context.Response.Clear();
        context.Response.ContentType = "application/ms-excel";   
        context.Response.OutputStream.Write(byteArray, 0, byteArray.Length);       
        context.Response.End();    
    }    
    catch (Exception ex)    
    {       
        SendMail(ex.Message.ToString());    
    }
...

it throws me this: 'context.Response.Headers' threw an exception of type 'System.PlatformNotSupportedException' — Tobi James, Oct 22 '12 at 20:49
mmm, is your app pool on integrated mode? If not, try with integrated mode. — danielQ, Oct 22 '12 at 21:15

Create an excel file in ashx from byte[] array for client download

1 Answers1