Renderizzare un report .rdlc in formato excel

C#: Report.aspxCopia

namespace SgartWebApplicationReport
{
  public partial class _Default : System.Web.UI.Page
  {
    protected void Page_Load(object sender, EventArgs e)
    {
        //i dati da passare al report
        DataTable tbl = GetDatasetTest();
        //invio il report al browser
        RenderReport("Report1.rdlc", tbl, "ReportDiProva");
    }

    private DataTable GetDatasetTest()
    {
      DsTestReport ds = new DsTestReport();
      DsTestReport.TblTestDataTable tbl =  ds.TblTest;
      
      DsTestReport.TblTestRow row = null;

      row = tbl.NewTblTestRow();
      row.Description = "Generare dataset";
      row.Date = new DateTime(2012, 2,22);
      row.Number = 20.4m;
      tbl.Rows.Add(row);

      row = tbl.NewTblTestRow();
      row.Description = "Creare report rdlc";
      row.Date = new DateTime(2012, 2, 23);
      row.Number = 14560.78m;
      tbl.Rows.Add(row);

      row = tbl.NewTblTestRow();
      row.Description = "Creare pagina aspx/ashx ";
      row.Date = new DateTime(2012, 11, 24);
      row.Number = 360.56m;
      tbl.Rows.Add(row);

      return ds.TblTest;
    
    }
 
     /// <summary>
    /// Microsoft.ReportViewer.Common.dll
    /// Microsoft.ReportViewer.WebForms.dll
    /// </summary>
    /// <param name="reportName"></param>
    /// <param name="dt"></param>
    /// <param name="fileName"></param>
    private void RenderReport(string reportName, DataTable dt, string fileName)
    {
      LocalReport localReport = new LocalReport();
      localReport.ReportPath = Server.MapPath(reportName);

      //dt.TableName: deve coincidere con il nome del dataset definito nel report (rd:DataSetName)
      ReportDataSource reportDataSource = new ReportDataSource(dt.TableName, dt);
      localReport.DataSources.Add(reportDataSource);

       // se si hanno delle eccezioni di security può essere necessario inserire queste righe
       // soprattutto se il report gira all'interno di SharePoint 
       // In alternativa impostare il trust nel web.config a Full
       // Assembly myAssembly = Assembly.GetExecutingAssembly();
       // localReport.ExecuteReportInCurrentAppDomain(myAssembly.Evidence);
       // localReport.AddTrustedCodeModuleInCurrentAppDomain(myAssembly.FullName);

      string reportType = "EXCEL";
      string mimeType;
      string encoding;
      string fileNameExtension;

      //The DeviceInfo settings should be changed based on the reportType
      //http://msdn2.microsoft.com/en-us/library/ms155397.aspx
      string deviceInfo =
      "<DeviceInfo>" +
      "  <OutputFormat>EXCEL</OutputFormat>" +
      "  <PageWidth>21cm</PageWidth>" +
      "  <PageHeight>29.7cm</PageHeight>" +
      "  <MarginTop>0.5cm</MarginTop>" +
      "  <MarginLeft>0.5cm</MarginLeft>" +
      "  <MarginRight>0.5cm</MarginRight>" +
      "  <MarginBottom>0.5cm</MarginBottom>" +
      "</DeviceInfo>";
      Warning[] warnings;
      string[] streams;
      byte[] renderedBytes;

      //Render the report
      renderedBytes = localReport.Render(
          reportType,
          deviceInfo,
          out mimeType,
          out encoding,
          out fileNameExtension,
          out streams,
          out warnings);

      Response.Clear();
      Response.ContentType = mimeType;
      Response.AddHeader("content-disposition", "inline; filename=" + fileName + "." + fileNameExtension);
      Response.BinaryWrite(renderedBytes);
      Response.End();
    }
  }
}