Epplus 设置excel 页边距 及多文件合并

1：使用epplus合并多个excel文件到同一excel的不同sheet页中

  

 private static bool MergeExcelstring _stFilePath, List<string> _listFiles, string _stSaveFileName)
        {
            ExcelPackage epMergeFile = new ExcelPackage);
            bool result = true;
            try
            {
                string stSheetName = string.Empty;
                foreach string item in _listFiles)
                {
                    if !FileIsHave_stFilePath + "\" + item)) continue;
                    FileInfo newFile = new FileInfo_stFilePath + "\" + item);
                    //开启
                    using ExcelPackage pck = new ExcelPackagenewFile))
                    {
                        //设定ExcelWorkBook
                        ExcelWorkbook workBook = pck.Workbook;
                        if workBook != null)
                        {
                            if workBook.Worksheets.Count > 0)
                            {
                               //设置excel表格的页边距
                                //workBook.Worksheets[1].PrinterSettings.TopMargin = 10M / 2.54M;
                                stSheetName = item.Substring0, item.LastIndexOf'.'));
                                epMergeFile.Workbook.Worksheets.AddstSheetName, workBook.Worksheets[1]);
                            }
                        }
                    }
                }
            }
            catch Exception ex)
            {
                result = false;
                Debug.WriteLine"合并文件失败:" + ex.Message);
                throw new Exception"合并文件失败！");
            }

            if result)
            {
                string stFile = _stFilePath + "\" + _stSaveFileName;
                epMergeFile.SaveAsnew FileInfostFile));
                epMergeFile.Dispose);
            }

            return result;
        }

　　2：设置excel文件sheet页的 页边距（使用epplus）