using OfficeOpenXml;
using OfficeOpenXml.Style;
public void ExportBLL(string modelFilePath, string saveFilePath)
{
//文件拷贝
File.Copy(modelFilePath, saveFilePath);
FileInfo saveFile = new FileInfo(saveFilePath);
//打开Excel编辑
using (ExcelPackage package = new ExcelPackage(saveFile))
{
ExcelWorksheet worksheet = null;
//新建编辑表单
//编辑
worksheet = package.Workbook.Worksheets.Copy("报价表", "报价清单");
if (dt_Product == null)
{
return;
}
//根据产品数量插入行
int num = dt_Product.Rows.Count;
decimal count = 0;
if (num > 1)
worksheet.InsertRow(8, num-1);
}
}
相似问题