public void Import()
{
Range data = WorkSheet.GetDataRange();
var sheet = WorkSheet;
for (int r = 1; r < data.RowCount; r++)
{
var errorCell = sheet.Cells[r, data.ColumnCount + 1];
var obj = this.WorkBook.DataObjectSpace.CreateObject(ClassInfo.TypeInfo.Type) as XPBaseObject;
this.WorkBook.AddMapping(obj, sheet.Rows[r]);
foreach (var item in Columns)
{
item.Value.ImportCell(obj, sheet.Cells[r, item.Value.ColumnIndex]);
}
}
}