Export BDC(Business Data Catalog) Data to Excel/PDF

<%@ Assembly Name="mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" %> 
<%@ Assembly Name="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>   
<%@ Assembly Name="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" %> 
<%@ Assembly Name="Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> 
<%@ WebHandler Language="C#" Class="ExcelExporter" %> 
 
using System;  
using System.Web;  
using System.Web.UI;  
using System.Web.SessionState;  
using System.Collections;  
using System.Collections.Generic;  
using Microsoft.SharePoint;  
using Microsoft.Office.Server.ApplicationRegistry.MetadataModel;  
using Microsoft.Office.Server.ApplicationRegistry.Infrastructure;  
using Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db;  
 
public class ExcelExporter : IHttpHandler, IReadOnlySessionState  
{  
  public bool IsReusable {  
    get { return false; }  
  }  
  public void ProcessRequest(HttpContext context) {  
    SPSite siteColl = SPContext.Current.Site;  
    SPWeb site = SPContext.Current.Web;  
    Boolean first = true;  
 
    context.Response.ContentType = "application/vnd.ms-excel";  
    try  
    {  
        NamedLobSystemInstanceDictionary ObjInstances = ApplicationRegistry.GetLobSystemInstances();  
        LobSystemInstance objInstance = ObjInstances[(string)context.Session["Entity"]];  
        Entity ObjEntity = ObjInstance.GetEntities()[(string)context.Session["Instance"]];  
        MethodInstance ObjMethodInstance = ObjEntity.GetMethodInstances()[(string)context.Session["Method"]];  
          
        DbEntityInstanceEnumerator ObjEnum = (DbEntityInstanceEnumerator)ObjEntity.Execute(ObjMethodInstance, ObjInstance);  
 
        List<string> displayedFields = (List<string>)context.Session["Fields"];  
        while (ObjEnum.MoveNext())  
        {  
            DbEntityInstance dbInstance = (DbEntityInstance)ObjEnum.Current;  
            string s = dbInstance.ToString();  
            Microsoft.Office.Server.ApplicationRegistry.MetadataModel.View v = dbInstance.ViewDefinition;  
            if (first)  
            {  

                FieldCollection titles = v.Fields;  
                foreach (Field title in titles)  
                {  
                    if (filterFields)  
                    {  
                        if (displayedFields.Contains(title.Name))  
                        {  
                            string titleName;  
                            if (title.ContainsLocalizedDisplayName)  
                            {  
                                titletitleName = title.LocalizedDisplayName;  
                            }  
                            else  
                            {  
                                titletitleName = title.DefaultDisplayName;  
                            }  
                            context.Response.Write(titleName);  
                            context.Response.Write('\t');  
                        }  
                    }  
                    else  
                    {  

                        string titleName;  
                        if (title.ContainsLocalizedDisplayName)  
                        {  
                            titletitleName = title.LocalizedDisplayName;  
                        }  
                        else  
                        {  
                            titletitleName = title.DefaultDisplayName;  
                        }  
                        context.Response.Write(titleName);  
                        context.Response.Write('\t');  
                    }  
                }  
                context.Response.Write("\n");  
                first = false;  
            }  
 
 
            FieldCollection c = v.Fields;  
            foreach (Field f in c)  
            {  
                if (filterFields)  
                {  
                    if (displayedFields.Contains(f.Name))  
                    {  
                        TypeDescriptor td = f.TypeDescriptor;  
                        Object vName = dbInstance.GetFormatted(f.Name);  
                        context.Response.Write(vName);  
                        context.Response.Write('\t');  
                    }  
                }  
                else  
                {  

                    TypeDescriptor td = f.TypeDescriptor;  
                    Object vName = dbInstance.GetFormatted(f.Name);  
                    context.Response.Write(vName);  
                    context.Response.Write('\t');  
                }  
            }  
            context.Response.Write("\n");  
        }  
        ObjEnum.Dispose();  
    }  
    catch (Exception exception)  
    {  
        context.Response.Write("Error reading:\tBDC");  
        context.Response.Write("\n");  
        context.Response.Write("Entity:\t" + context.Session["Entity"]);  
        context.Response.Write("\n");  
        context.Response.Write("Instance:\t" + context.Session["Instance"]);  
        context.Response.Write("\n");  
        context.Response.Write("Method:\t" + context.Session["Method"]);  
    }  
  }  
}