I am trying to create an excel spreadsheet like so in EPPlus:
My main trouble stem from getting the drop down to appear. I understand this can be easily done in desktop Excel by selecting the Data -> Filter tool.
Is there any way to achieve this result using EPPlus? (Or any other built in .NET method)
I achived this result using the following line of code:
ws.Cells[$"A{row}:S{row}"].AutoFilter = true;
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