将数据导出到报表Excel模板 [英] Exporting Data To a Reporting Excel Template

问题描述

怪胎，
我确实有一个excel报告模板，需要使用SQL Server的数据填充该报告模板，我如何才能有效地实现此方案(将数据从SQL Server导出到报告excel模板，C#)

Hi Geeks,
I do have an excel reporting template of which needs to be populated with data from SQL Server, how can i efficiently implement this scenario (Exporting data from SQL Server to a reporting excel template, C#)

推荐答案

这是在excel中导出数据的简单解决方案

This is a simple solution to export Data in excel

ReportDocument rptDoc = new ReportDocument();
...
rptDoc.ExportToHttpResponse(ExportFormatType.Excel, this.Response, false, null);

但是不清楚您是否动态调用报告?

But it is not clear are you calling report dynamically or not?

这篇关于将数据导出到报表Excel模板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！