基于NPOI的Excel工具

	public class ExcelToolsOpr
    {
		/// <summary>
        /// 根据模板导出Excel
        /// </summary>
        /// <param name="templatePath">模板位置</param>
        /// <param name="exportPath">导出文件的文件夹路径</param>
        /// <param name="fileName">文件名(不需要后缀)</param>
        /// <param name="queryCon">相关条件</param>
        public static void ExportExcelByTemplate(string templatePath, string exportPath, string fileName, QueryCon queryCon){
            //....
        }
        
        //...
    }

    //请求对象
    public class QueryCon
    {
        //循环复制的条件
        public List<LoopCon> LoopCons { get; set; }
		
        //请求数据
        public DataSet DataSet { get; set; }
    }

    public class LoopCon
    {
        /// <summary>
        /// 循环关键字
        /// </summary>
        public string Key { get; set; }

        /// <summary>
        /// 间隔行数
        /// </summary>
        public int SpaceRowCnt { get; set; }

        /// <summary>
        /// 循环测试
        /// </summary>
        public int LoopCount { get; set; }
    }

	public class ExcelToolsOpr
    {
        /// <summary>
        /// 根据DataSet导出Excel
        /// </summary>
        /// <typeparam name="T">HSSFWorkbook:是操作Excel2003以前（包括2003）的版本，扩展名是.xls；XSSFWorkbook、SXSSFWorkbook:是操作Excel2007后的版本，扩展名是.xlsx；</typeparam>
        /// <param name="ds">DataSet</param>
        /// <param name="exportPath">导出文件的文件夹路径</param>
        /// <param name="fileName">文件名(不需要后缀)</param>
        /// <param name="titleFlag">是否使用TableName作为标题显示</param>
        public static void DataSetToExcel<T>(DataSet ds, string exportPath, string fileName,
            bool titleFlag = false, CellStyle titleStyle = null, CellStyle colStyle = null, CellStyle contentStyle = null) where T : IWorkbook, new()
        {
            //....
        }
        
        //...
    }