예제 #1
0
    private List <IntegraDUExcel> ReestrSheet()
    {
        Excel.Worksheet WSSource = Globals.ThisAddIn.Application.Sheets["Реестр"];
        EnableCalculations(false);
        Globals.ThisAddIn.Application.CopyObjectsWithCells = true;
        ExcelLoader _excelLoader = new ExcelLoader(Globals.ThisAddIn.Application);

        _excelLoader.AttachRows(WSSource);
        return((from row in _excelLoader.Rows
                where row.UNIU != null
                orderby row.AddressObject, row.AddressHouse
                select row).ToList());
    }