public class ExcelHelper {

        /// <summary>

        /// 文件名

        /// </summary>

        public string fileName { get; set; }

        /// <summary>

        /// 工作簿列表

        /// </summary>

        public List<WorkSheet> workSheets { get; set; }

        /// <summary>

        /// Excel文档对象

        /// </summary>

        public XlsDocument doc { get; set; }

        public string message { get; set; }

        public ExcelHelper() {

            doc = new XlsDocument();

            workSheets = new List<WorkSheet>();

        }

        /// <summary>

        /// 导出Excel

        /// </summary>

        /// <returns></returns>

        public bool ToExcel() {

            if (string.IsNullOrEmpty(fileName)) {

                message = "请输入文件名";

                return false;

            }

            if (workSheets.Count == ) {

                message = "请指定工作簿数据";

                return false;

            }

            doc.FileName = fileName;

            foreach (var workSheet in workSheets) {

                AppLibrary.WriteExcel.Worksheet sheet = null;

                //判断Worksheet是否存在

                try {

                    sheet = doc.Workbook.Worksheets[workSheet.name];

                } catch (Exception ex) {

                    sheet = doc.Workbook.Worksheets.Add(workSheet.name);

                }

                AppLibrary.WriteExcel.Cells cells = sheet.Cells;

                var dt = workSheet.table;

                for (int j = ; j <= dt.Columns.Count - ; j++) {

                    if (workSheet.xf != null) {

                        cells.Add(workSheet.startX, workSheet.startY + j, dt.Columns[j].ColumnName, workSheet.xf);

                    } else {

                        cells.Add(workSheet.startX, workSheet.startY + j, dt.Columns[j].ColumnName);

                    }

                }

                for (int i = ; i <= dt.Rows.Count - ; i++) {

                    for (int j = ; j <= dt.Columns.Count - ; j++) {

                        cells.Add(i +  + workSheet.startX, j + workSheet.startY, dt.Rows[i][j].ToEString());

                    }

                }

            }

            doc.Send();

            return true;

        }

    }

    public class WorkSheet {

        private int _startX = ;

        private int _startY = ;

        public string name { get; set; }

        public DataTable table { get; set; }

        public int startX {

            get {

                return _startX;

            }

            set {

                if (value > ) {

                    _startX = value;

                }

            }

        }

        public int startY {

            get {

                return _startY;

            }

            set {

                if (value > ) {

                    _startY = value;

                }

            }

        }

        public AppLibrary.WriteExcel.XF xf { get; set; }

    }

　　　　　　  ExcelHelper excel = new ExcelHelper();

            excel.fileName = batchNo + ".xls";

            //汇总

            sql = string.Format(@"SELECT * from SKU WHERE batchNo='{0}'", batchNo);

            ret = dbHelper.Query(sql);

            AppLibrary.WriteExcel.XF xfcolumn = excel.doc.NewXF();

            xfcolumn.Font.Bold = true;

            xfcolumn.Pattern = ;

            xfcolumn.PatternColor = AppLibrary.WriteExcel.Colors.Cyan;

            excel.workSheets.Add(new WorkSheet() { name = "自动汇总", table = ret.Tables[], xf = xfcolumn });

            #region 设置样式
　　　　　　  //设置单元格样式

            var xf = doc.NewXF();

            xf.UseBorder = true;

            xf.LeftLineStyle = ;

            xf.RightLineStyle = ;

            xf.TopLineStyle = ;

            xf.BottomLineStyle = ;

            xf.LeftLineColor = AppLibrary.WriteExcel.Colors.Black;

            xf.RightLineColor = AppLibrary.WriteExcel.Colors.Black;

            xf.TopLineColor = AppLibrary.WriteExcel.Colors.Black;

            xf.BottomLineColor = AppLibrary.WriteExcel.Colors.Black;

            xf.UseFont = true;

　　　　　　  //设置表头样式

            var thXf = doc.NewXF();

            thXf.Pattern = ;

            thXf.PatternColor = AppLibrary.WriteExcel.Colors.Default1B;

            thXf.UseBorder = true;

            thXf.LeftLineStyle = ;

            thXf.RightLineStyle = ;

            thXf.TopLineStyle = ;

            thXf.BottomLineStyle = ;

            thXf.LeftLineColor = AppLibrary.WriteExcel.Colors.Black;

            thXf.RightLineColor = AppLibrary.WriteExcel.Colors.Black;

            thXf.TopLineColor = AppLibrary.WriteExcel.Colors.Black;

            thXf.BottomLineColor = AppLibrary.WriteExcel.Colors.Black;

            thXf.Font.Bold = true;

            #endregion

            #region 宽度

            AddColumnInfo(doc, sheet, , , );

            AddColumnInfo(doc, sheet, , , );

            AddColumnInfo(doc, sheet, , , );

            #endregion

　　　　　　  private static void AddColumnInfo(AppLibrary.WriteExcel.XlsDocument doc, AppLibrary.WriteExcel.Worksheet sheet, int start, int end, int width) {

            AppLibrary.WriteExcel.ColumnInfo colInfo = new AppLibrary.WriteExcel.ColumnInfo(doc, sheet);

            colInfo.ColumnIndexStart = (ushort)start;

            colInfo.ColumnIndexEnd = (ushort)end;

            colInfo.Width = (ushort)(width * );

            sheet.AddColumnInfo(colInfo);

        }