Is there any way to update caption of excelsheet's Slicers using c# code for spire.xls
I have tried some part of code googled through internet but it was only for PivotTables and not for the Slicers. I need help for the mentioned concern about Slicers of the excelsheet.
Jitendra SinghPosted Jun 20, 2024, 7:49 AM
It is not working, there is no any such option available. Even I have verified that Spire.xls are included by command "using Spire.Xls;"
Jayraj ChhayaPosted Jun 20, 2024, 7:31 AM
To update the captions of an Excel sheet's Slicers using C# with Spire.XLS, you can achieve this by accessing the SlicerCache object associated with the Slicer and then updating its Caption property.