paulyoder
Possible to map two columns into a single property?
If have a spreadsheet that contains vectors, stored in two or three columns.
Is there a way to get LinqToExcel to map these two or three columns directly into a property?
Example: Property might be called MyPosition. Columns might be called MyPosition_x, MyPosition_y, MyPosition_z.
This would be a very useful addition. I guess it would have to be routed via a transformation so that you have control of how the end mapping should be achieved.
For example, you might want to concatenate three columns but trim off the last 4 chars of the second field. Or you might require a specific deliminator between the fields. You might even not want to concatenate but perhaps just pick the largest number from the columns.
Perhaps some way of accessing the entire row object from a transformation might be possible?
