1 public class KpiTemplateExcelHelper
  2     {
  3         private IWorkbook _workBook = null;
  4         public IWorkbook workBook
  5         {
  6             get { return _workBook; }
  7         }
  8         private FileStream _fsOld = null;
  9         
 10         /// <summary>
 11         /// 用于暂时存储临时生成的文件名
 12         /// </summary>
 13         private string _temporaryWorkName;
 14 
 15         private readonly string domainPath = AppDomain.CurrentDomain.BaseDirectory;
 16 
 17         private KpiTemplateExcelHelper() { }
 18         public KpiTemplateExcelHelper(string workName)
 19         {
 20             _temporaryWorkName = workName + "Temporary" + ".xls";
 21             string filePath = this.GetFilePath(workName + ".xls");
 22             this.WorkBookInitialization(out _workBook,filePath);
 23         }
 24 
 25         /// <summary>
 26         /// 获取文件地址
 27         /// </summary>
 28         /// <param name="workName">考核表模板名称</param>
 29         /// <returns></returns>
 30         public string GetFilePath(string workName)
 31         {
 32             string filePath = domainPath + @"template\" + workName;
 33             if(!System.IO.File.Exists(filePath))
 34             {
 35                 throw new Exception("此文件不存在，请于管理员联系！");
 36             }
 37             return filePath;
 38         }
 39 
 40         /// <summary>
 41         /// 初始化Excel读取
 42         /// </summary>
 43         /// <param name="workBook"></param>
 44         /// <param name="filePath"></param>
 45         public void WorkBookInitialization(out IWorkbook workBook,string filePath)
 46         {
 47             try
 48             {
 49                 using(_fsOld = new FileStream(filePath,FileMode.Open,FileAccess.ReadWrite))
 50                 {
 51                     if(filePath.IndexOf(".xls") <= 0)
 52                     {
 53                         throw new Exception("此文件格式不正确，请于管理员联系！");
 54                     }
 55                     workBook = new HSSFWorkbook(_fsOld);
 56                 }
 57             }
 58             catch(Exception e)
 59             {
 60                 throw e;
 61             }
 62             finally
 63             {
 64                 _fsOld.Close();
 65             }
 66         }
 67 
 68         /// <summary>
 69         /// 对处理过的文件进行另存为新文件并返回、同时删除新文件
 70         /// </summary>
 71         /// <param name="oldWorkBook"></param>
 72         /// <returns></returns>
 73         public IWorkbook GetTemplateWork(IWorkbook oldWorkBook)
 74         {
 75             try
 76             {
 77                 string filePath = domainPath + @"template\" + _temporaryWorkName;
 78                 if(System.IO.File.Exists(filePath))
 79                 {
 80                     System.IO.File.Delete(filePath);
 81                 }
 82                 using(_fsOld = new FileStream(filePath,FileMode.CreateNew,FileAccess.ReadWrite))
 83                 {
 84                     _fsOld.Flush();
 85                     oldWorkBook.Write(_fsOld);
 86                     _fsOld.Close();
 87                     FileStream _fsNew = null;
 88                     try
 89                     {
 90                         using(_fsNew = new FileStream(filePath,FileMode.Open,FileAccess.Read))
 91                         {
 92                             if(filePath.IndexOf(".xls") <= 0)
 93                             {
 94                                 throw new Exception("此文件格式不正确，请于管理员联系！");
 95                             }
 96                             var newWorkBook = new HSSFWorkbook(_fsNew);
 97                             _fsNew.Close();
 98                             System.IO.File.Delete(filePath);
 99                             return newWorkBook;
100                         }
101                     }
102                     catch(Exception e)
103                     {
104                         throw e;
105                     }
106                     finally
107                     {
108                         _fsNew.Close();
109                     }
110                 }
111             }
112             catch(Exception e)
113             {
114                 throw e;
115             }
116             finally
117             {
118                 _fsOld.Close();
119             }
120         }
121     }