COMM/ExeclHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.IO;
using System.Text;
using System.Data;
using System.Reflection;
using System.Diagnostics;
using System.Collections;
using Excel = Microsoft.Office.Interop.Excel;
namespace COMM.ExeclHelper
{

  public class ExcelHelper
        {
            #region 成员变量
            private string templetFile = null;
            private string outputFile = null;
            private object missing = Missing.Value;
            private DateTime beforeTime;			//Excel启动之前时间
            private DateTime afterTime;				//Excel启动之后时间
            Excel.Application app;
            Excel.Workbook workBook;
            Excel.Worksheet workSheet;
            Excel.Range range;
            Excel.Range range1;
            Excel.Range range2;
            Excel.TextBox textBox;
            private int sheetCount = 1;			//WorkSheet数量
            private string sheetPrefixName = "页";
            #endregion

            #region 公共属性
            /// <summary>
            /// WorkSheet前缀名，比如：前缀名为“页”，那么WorkSheet名称依次为“页-1，页-2...”
            /// </summary>
            public string SheetPrefixName
            {
                set { this.sheetPrefixName = value; }
            }

            /// <summary>
            /// WorkSheet数量
            /// </summary>
            public int WorkSheetCount
            {
                get { return workBook.Sheets.Count; }
            }

            /// <summary>
            /// Excel模板文件路径
            /// </summary>
            public string TempletFilePath
            {
                set { this.templetFile = value; }
            }

            /// <summary>
            /// 输出Excel文件路径
            /// </summary>
            public string OutputFilePath
            {