Uses of linq in Excel automation

Learn
1

Hi
I wanted to know what activities we can do using Linq to automate excel other than sorting/filtering

Thanks

2

I have come across functions like

  • String manipulations for a column.

  • Update a column based on other