WordExcel报表源码.docVIP

WordExcel报表源码 using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Windows.Forms; using System.Collections; using System.IO; using System.Reflection; using System.Data.OleDb; using System.Drawing; using Aspose.Words; using Aspose.Cells; namespace Lqjt { /// summary /// 报表输出的操作 /// /summary public class ReportsCorrelation { /// summary /// 存放报表模板的表名 /// /summary public string ReportTableName = SpecialTableName.ReportTableName; /// summary /// EXCEL报表自动完成后,由具体功能进行后续处理的委托函数定义 /// /summary /// param name=p_ReportTableName选择的报表名称/param /// param name=p_Starty报表实际数据开始的列/param /// param name=p_Startx报表实际数据开始的行/param /// param name=p_Width报表实际数据的列数/param /// param name=p_ExcelSheet当前操作的Excel.Worksheet/param /// param name=p_Table存放数据的表/param public delegate void AfterProExcelDef(string p_ReportTableName, int p_Starty, int p_Startx, int p_Width, Worksheet p_ExcelSheet, DataTable p_Table); /// summary /// AfterProExcelDef的具体实例 /// /summary public AfterProExcelDef AfterProExcel = null; /// summary /// 利用Word生成简历式报表 /// /summary /// param name=p_Table存放实际的数据/param /// param name=p_FileName已下载的文件名/param public void MakeDetailReport(DataTable p_Table, string p_FileName) { try { //word采用邮件合并,因此,手工添加操作员/今日两个特殊域 DataTable tb = p_Table.Copy(); DataColumn col = new DataColumn({操作员}, typeof(string)); tb.Columns.Add(col); col = new DataColumn({今日}, typeof(string)); tb.Columns.Add(col); string strOp = Lqjt.OpInfo.OpName; string strToday = Tools.DateTimeToStr(Tools.Today); foreach (DataRow row in tb.Rows) { row[{操作员}] = strOp