private void GetSheets(ExcelMappingElement excelMappingElement)
{
foreach (var sheetElement in excelMappingElement.Sheets)
{
Sheets.Add(new SheetConfig
{
NoSheet = sheetElement.NoSheet,
SheetName = sheetElement.SheetName,
RowNumberStartData = sheetElement.RowNumberStartData,
RowNumberStopData = string.IsNullOrEmpty(sheetElement.RowNumberStopData) ? -1 : int.Parse(sheetElement.RowNumberStopData),
Map = sheetElement.Map
});
}
}
private void GetMappers(ExcelMappingElement excelMappingElement)
{
foreach (var mapperElement in excelMappingElement.Mappers)
{
var mapper = new MapperConfig(mapperElement.Name);
foreach (var mapElement in mapperElement.MapElements)
{
mapper.Maps.Add(new MapConfig
{
NoColumn = string.IsNullOrEmpty(mapElement.NoColumn) ? -1: int.Parse(mapElement.NoColumn),
Attribute = mapElement.Attribute,
Ignore = mapElement.Ignore,
Default = mapElement.Default,
Format = mapElement.Format,
AttributeType = string.IsNullOrEmpty(mapElement.AttributeType) ? "String" : mapElement.AttributeType
});
}
Mappers.Add(mapper);
}
}
