Class ExcelImportEngine

Namespace

TimeCockpit.Data.Import.Excel

Assembly

TimeCockpit.Data.Import.dll

public class ExcelImportEngine : ImportEngine

Inheritance

Object

ImportEngine

ExcelImportEngine

Inherited Members

ImportEngine.FormatStatusMessage(Int32, Boolean)

ImportEngine.PreprocessValue(DataContext, ModelEntityBase, ImportColumnDefinition, Object)

ImportEngine.PerformPostProcessExpressions(DataContext, EntityObject, IEnumerable<ImportColumnDefinition>, Boolean)

ImportEngine.PerformImport(ImportBookDefinition, Boolean, Byte[], String, Guid, Nullable<Guid>, Nullable<CancellationToken>)

ImportEngine.ImportSheet(ImportSheetDefinition)

ImportEngine.ImportRow(ImportColumnDefinition[], EntityObject, Boolean)

ImportEngine.GetKeyValue(DataContext, ModelEntityBase, Dictionary<ImportColumnDefinition, Int32>, ImportColumnDefinition, Dictionary<ImportColumnDefinition, ModelProperty>, Object)

ImportEngine.TryFindRelation(ImportColumnDefinition, Relation, String, Boolean, EntityObject)

ImportEngine.TrySetProperty(ImportColumnDefinition, ModelProperty, EntityObject, Object)

ImportEngine.AddMessage(ImportMessage.Kind, String)

ImportEngine.AddMessage(Exception)

ImportEngine.ImportColumn(ImportColumnDefinition, Object, EntityObject, Boolean)

ImportEngine.MessageCount

ImportEngine.SourceFileName

ImportEngine.OriginalSource

ImportEngine.DataContext

ImportEngine.DefinitionName

ImportEngine.OnProgress

ImportEngine.OnMessage

ImportEngine.OnReportFinished

ImportEngine.OnEntityObjectSaved

Object.ToString()

Object.Equals(Object)

Object.Equals(Object, Object)

Object.ReferenceEquals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Constructors

ExcelImportEngine(DataContext)

public ExcelImportEngine(DataContext dataContext)

Parameters

dataContext DataContext

Properties

CurrentRowCount

public override int CurrentRowCount { get; }

Property Value

Int32

SourceWorkbook

public XLWorkbook SourceWorkbook { get; }

Property Value

XLWorkbook

Methods

FetchUpdateKeys(ImportColumnDefinition[], ModelEntityBase, Int32)

protected override Dictionary<int, string> FetchUpdateKeys(ImportColumnDefinition[] keyColumns, ModelEntityBase targetEntity, int defaultHeaderRowNumber = 1)

Parameters

keyColumns ImportColumnDefinition[]

targetEntity ModelEntityBase

defaultHeaderRowNumber Int32

Returns

Dictionary<Int32, String>

GetCellKeyValue(ImportColumnDefinition)

public override object GetCellKeyValue(ImportColumnDefinition column)

Parameters

column ImportColumnDefinition

Returns

Object

GetCellValue(ImportColumnDefinition)

public override object GetCellValue(ImportColumnDefinition column)

Parameters

column ImportColumnDefinition

Returns

Object

GetCellValueBoolean(Object, out Boolean)

protected override bool GetCellValueBoolean(object cellValue, out bool b)

Parameters

cellValue Object

b Boolean

Returns

Boolean

GetCellValueDateTime(Object, out DateTime)

protected override bool GetCellValueDateTime(object cellValue, out DateTime dt)

Parameters

cellValue Object

dt DateTime

Returns

Boolean

GetCellValueDecimal(Object, out Decimal)

protected override bool GetCellValueDecimal(object cellValue, out decimal d)

Parameters

cellValue Object

d Decimal

Returns

Boolean

GetCellValueGuid(Object, out Guid)

protected override bool GetCellValueGuid(object cellValue, out Guid g)

Parameters

cellValue Object

g Guid

Returns

Boolean

GetCellValueString(Object, out String)

protected override bool GetCellValueString(object cellValue, out string s)

Parameters

cellValue Object

s String

Returns

Boolean

GetReportData()

public override byte[] GetReportData()

Returns

Byte[]

GetReportMetadata(String, DateTime, out String, out String)

public override void GetReportMetadata(string definitionName, DateTime exportTimestamp, out string filename, out string mimeType)

Parameters

definitionName String

exportTimestamp DateTime

filename String

mimeType String

GetSourceMetadata(out String, out String)

public override void GetSourceMetadata(out string filename, out string mimeType)

Parameters

filename String

mimeType String

HasMoreRows()

public override bool HasMoreRows()

Returns

Boolean

IsCellEmpty(Object)

protected override bool IsCellEmpty(object cellValue)

Parameters

cellValue Object

Returns

Boolean

LoadPreviewData(Int32, Byte[], Dictionary<String, Int32>, Int32)

public override PreviewWorkbook LoadPreviewData(int sampleSize, byte[] sourceData, Dictionary<string, int> headerRowNumbers = null, int defaultHeaderRowNumber = 1)

Parameters

sampleSize Int32

sourceData Byte[]

headerRowNumbers Dictionary<String, Int32>

defaultHeaderRowNumber Int32

Returns

PreviewWorkbook

MoveToNextRow()

public override void MoveToNextRow()

PrepareImportSheet(ImportSheetDefinition)

public override bool PrepareImportSheet(ImportSheetDefinition sheetDefinition)

Parameters

sheetDefinition ImportSheetDefinition

Returns

Boolean

PrepareImportWorkbook(ImportBookDefinition)

public override bool PrepareImportWorkbook(ImportBookDefinition book)

Parameters

book ImportBookDefinition

Returns

Boolean

SavePreviewData(PreviewWorkbook)

public override byte[] SavePreviewData(PreviewWorkbook previewWorkbook)

Parameters

previewWorkbook PreviewWorkbook

Returns

Byte[]

SetRowMessage(ImportSheetDefinition, String, Boolean, Boolean)

public override void SetRowMessage(ImportSheetDefinition sheetDefinition, string text, bool isError, bool isModification)

Parameters

sheetDefinition ImportSheetDefinition

text String

isError Boolean

isModification Boolean