1
Vote

Add an Excel.Import() method to return POCO objects

description

I need to control the import of data from Excel such that Excel.Import() method returns a list of in memory POCO/objects of my choice (definition) which then I can filter and transfer them to a table avoiding any duplicates in the existing table.
By using reflection and ColumnMapping one can develop such a method to return in memory objects and not being tied up to a Lightswitch table ( IValueCollection).
See also my comment in this discussion: Excel.Import() discussion

comments