string localFileName = path + Path.DirectorySeparatorChar + fileName;

                FileInfo file = new FileInfo(localFileName);

                using (ExcelPackage package = new ExcelPackage(file))

                {

                    ExcelWorkbook wb = package.Workbook;

                    //配置文件属性

                    wb.Properties.Title = "库存导入模板";

                    // 添加worksheet

                    ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("商品库存");

                    //添加头

                    worksheet.Cells[, ].Value = "商品ID";

                    worksheet.Cells[, ].Value = "商品名称";

                    worksheet.Cells[, ].Value = "货号";

                    worksheet.Cells[, ].Value = "原价";

                    worksheet.Cells[, ].Value = "售价";

                    worksheet.Cells[, ].Value = "数量";

                    worksheet.Cells[, ].Value = "库存规格1";

                    worksheet.Cells[, ].Value = "库存规格2";

                    //获取当前商户库存数据模板

                    var items = _pser.GetImportInnentoryList(CurrentVendorID);

                    int rowindex = ;

                    foreach (var item in items)

                    {

                        rowindex++;

                        //添加值

                        worksheet.Cells[rowindex, ].Value = item.ProductID;

                        worksheet.Cells[rowindex, ].Value = item.ProductName;

                        worksheet.Cells[rowindex, ].Value = item.ArtNo;

                        worksheet.Cells[rowindex, ].Value = item.TagPrice;

                        worksheet.Cells[rowindex, ].Value = item.Price;

                        worksheet.Cells[rowindex, ].Value = item.Quantity;

                        worksheet.Cells[rowindex, ].Value = item.Specification1;

                        worksheet.Cells[rowindex, ].Value = item.Specification2;

                    }

                    package.Save();

                }