private static void SaveToExcelFile(Dictionary <string, object>[] rows, string filePath, string bindingFilePath)
{
using (var package = new ExcelPackage(new FileInfo(filePath)))
{
var workbookBinding = new WorkbookBinding(XDocument.Load(bindingFilePath));
PopulateWorkbook(rows, package.Workbook, workbookBinding);
package.Save();
}
}
private static void PopulateWorkbook(Dictionary <string, object>[] rows, ExcelWorkbook workbook, WorkbookBinding workbookBinding)
{
foreach (var worksheetBinding in workbookBinding.Worksheets)
{
var worksheet = workbook.Worksheets[worksheetBinding.Name];
if (worksheet != null)
{
PopulateWorksheet(rows, worksheet, worksheetBinding);
}
}
}