'Create Excel columns as dropdown list in .Net Core
I am new in .Net & in my .Net Core 5 API project there is a requirement to have particular column cells as dropdown list i.e., when the user clicks on any cell of that particular column (which will vary in different excels) it should show a dropdown list with options (the list can have more than 700 options), hence we have to also make it searchable. Our project is little old & its using EPPlus package (5+) to generate the excel sheet.
I was searching but unable to get any idea. Does anyone knows how to implement this ? Thanks in advance!!!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|