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()); }