rdlc导出Excel

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Reporting.WebForms;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;
using System.IO;


public partial class _Default : System.Web.UI.Page
{
    protected CrystalDecisions.CrystalReports.Engine.ReportDocument reportDocument1=new ReportDocument();
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void CrystalReportViewer1_Init(object sender, EventArgs e)
    {

    }
    protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
    {

    }

    protected void Button1_Click1(object sender, EventArgs e)
    {

        Microsoft.Reporting.WebForms.Warning[] Warnings;
        string[] streamids;
        string mimeType;
        string encoding;
        string fileNameExtension;

        Microsoft.Reporting.WebForms.LocalReport lr =
          new Microsoft.Reporting.WebForms.LocalReport();

        string deviceInfo =
          "<DeviceInfo>" +
          "<SimplePageHeaders>True</SimplePageHeaders>" +
          "</DeviceInfo>";

        lr.ReportPath = Server.MapPath("Report2.rdlc");

        lr.DataSources.Add(new ReportDataSource("DataSet1_ord", ObjectDataSource1));

        byte[] bytes = lr.Render("Excel", deviceInfo, out mimeType,
          out encoding,out fileNameExtension, out streamids, out Warnings);

        using (FileStream fs = new FileStream(@"C:\study_net2005\Report2.xls", FileMode.Create))
        {
            fs.Write(bytes, 0, bytes.Length);
            fs.Close();
        }

       //客户端不行
       // object o = System.Reflection.Missing.Value;
       // Excel.Application excelapp = new Excel.ApplicationClass();
       Excel.Workbook wkbook = excelapp.Workbooks.Open("C:\\study_net2005\\Report2.xls", o, o, o, o, o, o, o, o, o, o, o, o);
       // Excel.Workbook wkbook = excelapp.Workbooks.Open("C:\\study_net2005\\Report2.xls", o, o, o, o, o, o, o, o, o, o, o, o,o,o);
       // excelapp.Visible = true;      // //wkbook.PrintPreview(true);//预览  
       // wkbook.PrintOut(o, o, o, o, o, o, o, o);//打印  
       // wkbook.Save();
       // excelapp.Quit();

       

    }
}


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值