How to Convert IEnumerable<dynamic> to IEnumerable<T> ?

[lylezhan]

When I use this method IEnumerable QueryWithoutEmptyRow,
next how should I convert the result to generic IEnumerable？

Thank you

[shps951023]

Please use Query<T> method

[lylezhan]

How do I filter out empty rows using the method Query<T> ?

[samolulu]

同问，用Query读取时怎么过滤掉空行？

[michelebastione]

@lylezhan , @samolulu with this last PR you can use the OpenXmlConfiguration property IgnoreEmptyRows to achieve your goal. It will be available in the next release.