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 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();
}
}
http://hi.baidu.com/web_girl/blog/item/af53d33f603f53eb54e723e8.html
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· Blazor Hybrid适配到HarmonyOS系统
· Obsidian + DeepSeek:免费 AI 助力你的知识管理,让你的笔记飞起来!
· 解决跨域问题的这6种方案,真香!
· 一套基于 Material Design 规范实现的 Blazor 和 Razor 通用组件库
· 分享4款.NET开源、免费、实用的商城系统