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

最新推荐文章于 2021-12-29 19:29:50 发布

原创最新推荐文章于 2021-12-29 19:29:50 发布 · 2.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#excel #dataset #warnings #extension #string #encoding

VS.NET IDE 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一个使用XML文件加载销售数据到报表并将其导出为Excel格式的应用实例。该应用通过C#实现，包括从指定路径读取XML数据集、设置报表查看器参数以及将报表内容转换为Excel文件等功能。

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");

        }