I am using Aspose cells to manipulate Excel spreadsheets. One of the types in the API is a collection of Pictures in the spreadsheet, which derives from CollectionBase:
see this link: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/aspose.cells.pictures.html
I want to convert this type to something that allows me to use Linq expressions
What are the options for this?
I guess I could iterate over it and manually add it to a new List<Picture> But is there a better way to do this?
I have read this question Adding IEnumerable<T> to class derived from CollectionBase
But I obviously don't have control over the class that implements CollectionBace as it is a third party product
Just use the Enumerable.Cast<T>() extension method on the non-generic IEnumerable interface, which you can do implicitly in a query expression:
var query = from Picture picture in pictures where ... select ...; or explicitly, for instance if you want to use dot notation:
var query = pictures.Cast<Picture>() .Where(...) .Select(...); An alternative to Cast<T>() is OfType<T>() - which basically ignores any elements which aren't of the right type. In this case I think Cast<T>() is more appropriate though.
If you want to convert the whole collection to a List<T> for whatever reason, that's easy too:
List<Picture> list = pictures.Cast<Picture>().ToList();
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With