public ImportDesignTimeViewModel() { var columnHeaderList = new List<ColumnHeaderValue> { new ColumnHeaderValue {Caption = "TEST COLUMN HEADER"}, new ColumnHeaderValue {Caption = "TEST COLUMN HEADER 2"} }; var sheet1 = new SheetInfo { RelatedClients = new ObservableCollection<RelatedClientInfo> { new RelatedClientInfo { Client = new Client { Id = 17, ParentId = null, InnerId = 240, Name = "Траст", FullName = "ПАО НБ \"Траст\"", Image = "240-bank-trast.png" }, }, new RelatedClientInfo { Client = new Client { Id = 25, ParentId = null, InnerId = 251, Name = "Сбербанк", FullName = "ПАО «Сбербанк России»", Image = "251-sber-bank.png"} } }, ColumnHeaderList = columnHeaderList, SelectedColumnHeaderValue = columnHeaderList[0] }; WorkSheetsInBook = new ObservableCollection<SheetInfo> {sheet1, new SheetInfo()}; }
public ImportDesignTimeViewModel() { var columnHeaderList = new List <ColumnHeaderValue> { new ColumnHeaderValue { Caption = "TEST COLUMN HEADER" }, new ColumnHeaderValue { Caption = "TEST COLUMN HEADER 2" } }; var sheet1 = new SheetInfo { RelatedClients = new ObservableCollection <RelatedClientInfo> { new RelatedClientInfo { Client = new Client { Id = 17, ParentId = null, InnerId = 240, Name = "Траст", FullName = "ПАО НБ \"Траст\"", Image = "240-bank-trast.png" }, }, new RelatedClientInfo { Client = new Client { Id = 25, ParentId = null, InnerId = 251, Name = "Сбербанк", FullName = "ПАО «Сбербанк России»", Image = "251-sber-bank.png" } } }, ColumnHeaderList = columnHeaderList, SelectedColumnHeaderValue = columnHeaderList[0] }; WorkSheetsInBook = new ObservableCollection <SheetInfo> { sheet1, new SheetInfo() }; }
public void DocumentLoaded(object spreadSheet) { if (!(spreadSheet is SpreadsheetControl)) { return; } var workBook = ((SpreadsheetControl)spreadSheet).Document; foreach (var itemWorkSheet in workBook.Worksheets) { var sheetInfo = new SheetInfo { WorkSheet = itemWorkSheet, GoodColumns = GoodColumns }; sheetInfo.ParseWorkSheet(); var columnHeaders = new List <string>(); sheetInfo.ColumnHeaderList.ForEach(ch => columnHeaders.Add(ch.Caption)); WorkSheetsInBook.Add(sheetInfo); ImportService.AddColumnHeadersAsync(columnHeaders.ToArray(), sheetInfo); } }
public void DocumentLoaded(object spreadSheet) { if (!(spreadSheet is SpreadsheetControl)) return; var workBook = ((SpreadsheetControl) spreadSheet).Document; foreach (var itemWorkSheet in workBook.Worksheets) { var sheetInfo = new SheetInfo { WorkSheet = itemWorkSheet, GoodColumns = GoodColumns }; sheetInfo.ParseWorkSheet(); var columnHeaders = new List<string>(); sheetInfo.ColumnHeaderList.ForEach(ch => columnHeaders.Add(ch.Caption)); WorkSheetsInBook.Add(sheetInfo); ImportService.AddColumnHeadersAsync(columnHeaders.ToArray(), sheetInfo); } }