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