public int Export(string filename)
{
_logger.Info(LoggerMessage.GetFunctionUsageMessage("Export Addressbook"));
List <Person> persons = new List <Person>();
using (var session = _documentStoreFactory.CreateDocumentStore().OpenSession())
{
persons = session.LoadAll <Person>();
}
var excelPackage = new ExcelPackage();
excelPackage.Workbook.Properties.SetCustomPropertyValue("Version", 1);
var worksheet = excelPackage.Workbook.Worksheets.Add("Zugab");
var addressbookWorksheet = new AddressbookWorksheet(worksheet);
addressbookWorksheet.WritePersons(persons);
excelPackage.SaveAs(new FileInfo(filename));
return(persons.Count);
}
private IList <Person> ImportAddressbookExcel(ExcelWorksheet worksheet)
{
var addressbookWorksheet = new AddressbookWorksheet(worksheet);
return(addressbookWorksheet.ReadPersons());
}
