导出excel
Raw模式下 该如何导出? 您好,根据电话沟通的结果提供一个在HTML下使用js导出excel的例子程序。
使用的版本是AR9.3 回复 2楼frank.zhang的帖子
Raw模式下有咩有例子? 您好,
根据电话沟通的结果,导出可以参考以下代码:
protected void Button6_Click(object sender, EventArgs e)
{
// Provide the page report you want to render.
GrapeCity.ActiveReports.PageReport _reportDef = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(Server.MapPath("/Reports/" + report + ".rdlx")));
//_reportDef.Report.DataSources.DataSourceReference = "";
//_reportDef.Report.DataSources.ConnectionProperties.DataProvider = "OLEDB";
//_reportDef.Report.DataSources.ConnectionProperties.ConnectString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};", Server.MapPath("/Data/NWind_CHS.mdb"));
GrapeCity.ActiveReports.Document.PageDocument _reportRuntime = new GrapeCity.ActiveReports.Document.PageDocument(_reportDef);
// Create an output directory
System.IO.MemoryStream ms = new System.IO.MemoryStream();
// Provide settings for your rendering output.
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings
excelSetting = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings();
excelSetting.FileFormat = GrapeCity.ActiveReports.Export.Excel.Page.FileFormat.Xlsx;
//excelSetting.MultiSheet = false;
//excelSetting.Pagination = false;
GrapeCity.ActiveReports.Extensibility.Rendering.ISettings setting = excelSetting;
//Set the rendering extension and render the report.
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension
excelRenderingExtension = new
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension();
GrapeCity.ActiveReports.Rendering.IO.MemoryStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.MemoryStreamProvider();
_reportRuntime.Render(excelRenderingExtension, outputProvider, excelSetting.GetSettings());
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "inline;filename=中文说明.xlsx");
outputProvider.GetPrimaryStream().OpenStream().CopyTo(ms);
Response.BinaryWrite(ms.ToArray());
Response.End();
} 按照你所回复的结果,成功导出。但是又有一个问题,导出的格式和视图中的格式不一致
图一:表格格式原图
图二:表格格式导出的图
差异在于:原图中的BBB 导出不见了,CCC错位了,CCC中某些项目名称不见了 您好,
这个问题和报表模板的设计有关系,重现这个问题,我才能定位这个问题的具体原因,再看进一步的解决方案。
需要您提供一个能够重现这个问题的例子程序,包括报表模板和测试数据。 回复 6楼frank.zhang的帖子
mysql 数据库 navicat 备份导出 ,可能发给你? 文件已发 您好,
根据电话沟通的结果,相关资源已经下载到本地。
数据已经导入到数据库,但是我直接运行DataSet1的SQL语句,报
1146 - Table '111.vwqianfeitotalforcurrentyear' doesn't exist
还原的时候
1146 - Table '111.vwqianfeitotalbyitems' doesn't exist
Importing Data...
Rolling back...
Finished - Stopped before completion 您好,
您的问题我们已经重现,明天回继续调查。
页:
[1]
2