• 用rdlc文件直接导出到excel或PDF


    private DataTable LoadSalesData()
            {
                // Load data from XML file.
                DataSet dataSet = new DataSet();
                dataSet.ReadXml(@"c:\Reports\data.xml");
                return dataSet.Tables[0];
            }
           
            public Form1()
            {
                InitializeComponent();
            }

            private void Form1_Load(object sender, EventArgs e)
            {
                this.reportViewer1.ProcessingMode = ProcessingMode.Local;
                this.reportViewer1.LocalReport.ReportPath = @"c:\Reports\Report1.rdl";
                reportViewer1.LocalReport.DataSources.Add(
                new ReportDataSource("Sales", LoadSalesData()));
                this.reportViewer1.RefreshReport();
            }

            private void button1_Click(object sender, EventArgs e)
            {
                Warning[] warnings;
                string[] streamids;
                string mimeType;
                string encoding;
                string extension;

                byte[] bytes = reportViewer1.LocalReport.Render(
                   "Excel", null, out mimeType, out encoding, out extension,
                   out streamids, out warnings);

                FileStream fs = new FileStream(@"c:\output.xls", FileMode.Create);
                fs.Write(bytes, 0, bytes.Length);
                fs.Close();

                MessageBox.Show("Report exported to output.xls", "Info");

            }

    如果是BS模式,先保存在服务器上面,再从服务器上面下载下来

  • 相关阅读:
    Mac下Selenium无法最大化Chrome解决方案
    Mac环境配置好ant后提示Permission denied
    禁止Chrome浏览器自动升级
    Selenium滚动条window.scrollTo和window.scrollBy
    Windows和Linux如何使用Java代码实现关闭进程
    自动化测试框架Selenium工作原理
    Mac下用SSH连接远程Linux或Mac服务器
    mac显示隐藏文件
    Selenium自动化测试脚本中三种等待时间简介
    Java虚拟机之栈
  • 原文地址:https://www.cnblogs.com/hubj/p/1318114.html
Copyright © 2020-2023  润新知