private static void ImportToObject(this IRawSheetImporterPage page, RawSheetImporter importer, SheetConvertingContext context, object obj, int pageRow)
{
var type = obj.GetType();
var bindingFlags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.SetProperty;
for (int pageColumn = 0; !page.IsEmptyCell(pageColumn, 0); ++pageColumn)
{
var columnValue = page.GetCell(pageColumn, 0);
using (context.Logger.BeginScope(columnValue))
{
var cellValue = page.GetCell(pageColumn, pageRow);
if (string.IsNullOrEmpty(cellValue))
{
continue;
}
var prop = type.GetProperty(columnValue, bindingFlags);
if (prop == null)
{
continue;
}
try
{
object value = importer.StringToValue(prop.PropertyType, cellValue);
prop.SetValue(obj, value);
}
catch (Exception ex)
{
context.Logger.LogError(ex, "Failed to convert value \"{CellValue}\" of type {PropertyType}", cellValue, prop.PropertyType);
}
}
}
}
public static void Import(this IRawSheetImporterPage page, RawSheetImporter importer, SheetConvertingContext context, ISheet sheet)
{
var idColumnName = page.GetCell(0, 0);
if (idColumnName != nameof(ISheetRow.Id))
{
context.Logger.LogError("First column \"{ColumnName}\" must be named \"Id\"", idColumnName);
return;
}
ISheetRow sheetRow = null;
for (int pageRow = 1; !page.IsEmptyRow(pageRow); ++pageRow)
{
var rowId = page.GetCell(0, pageRow);
if (!string.IsNullOrEmpty(rowId))
{
using (context.Logger.BeginScope(rowId))
{
sheetRow = Activator.CreateInstance(sheet.RowType) as ISheetRow;
page.ImportToObject(importer, context, sheetRow, pageRow);
if (sheet.Contains(sheetRow.Id))
{
context.Logger.LogError("Already has row with id \"{RowId}\"", sheetRow.Id);
sheetRow = null;
}
else
{
sheet.Add(sheetRow);
}
}
}
if (sheetRow is ISheetRowArray sheetRowArray)
{
using (context.Logger.BeginScope(sheetRow.Id))
using (context.Logger.BeginScope(sheetRowArray.Arr.Count))
{
var sheetElem = Activator.CreateInstance(sheetRowArray.ElemType);
page.ImportToObject(importer, context, sheetElem, pageRow);
sheetRowArray.Arr.Add(sheetElem);
}
}
}
}
