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