Does Linq to Excel support joins?

[Nickname unavailable]

I'm interested in joining two sheets together, but cannot figure out
the Linq syntax. Is this possible?

Thanks, Nat

[Nickname unavailable]

I've somewhat figured this out on my own. I figured out the syntax and
got the message the LinqToExcel doesn't support joins. But if I
convert one or both of the tables into a list first, then joins work,
provided that the LinqToExcel table is on the right side of the join.

Nat

[Paul Yoder]

Nat,

You're correct that Linq to Excel does not natively support joins. However, as you have found out, you can use Linq to Excel to query both tables and convert each query into a list and then you can use linq joins on the lists.

Thanks for letting us know how you got joins working in Linq to Excel.

Paul