private List <IntegraHouses> HouseSheet()
{
Excel.Worksheet WSSource = Globals.ThisAddIn.Application.Sheets["Дома"];
EnableCalculations(false);
Globals.ThisAddIn.Application.CopyObjectsWithCells = true;
ExcelLoader _excelLoader = new ExcelLoader(Globals.ThisAddIn.Application);
_excelLoader.AttachHouses(WSSource);
return((from row in _excelLoader.Houses
where row.UNOM != null &&
!string.IsNullOrEmpty(row.UNOM.ToString())
orderby row.Address
select row).ToList());
}
