Our requirement has not been fulfilled.
We are using .Net core Console Application and i also noted below which reference currently using
we need to set the default filter value in existing excel sheet.
but your application code look as set the value in new sheet.Which you given for sample.
one more thing is even we tried your logic of code also we could not set the filter drop down default value (creating new sheet)
We are unable to reproduce the dropdown default value issue at our side. We have prepared a sample to set the default filter value in existing pivot table sheet which sample can be downloaded from the following link.
If your requirement is not met, then kindly modify and share us the issue reproducing sample. This will be helpful for us to provide prompt solution at the earliest.
we need whole Excel workbook password protection.
XlsIO does not support security features for ASP.NET core platform. However, we have added it to our Feature request list and it will be implemented in any of our upcoming releases.