Free Support Forum - aspose.com

Support to create/manipulate slicers

Can slicers be created/manipulated? If not, is it on the roadmap?


Alternatively, is there any sample to create/edit macros that edits slicers)

Hi,


Well, I am afraid, creating or manipulating Slicers in the spreadsheet are not supported yet. A ticket with an id “CELLSNET-42793” for the issue is already logged into our database, the feature is not going to be supported in near future too.

Regarding create macros/vba code to create/edit slicers, see the document for your reference:
http://www.contextures.com/excelslicersupdatevba.html

Thank you.

@kenskho,

We have supported the feature. Please try using our latest version/fix: Aspose.Cells for .NET v18.6. See the blog on how to create, manipulate or render Slicers in MS Excel workbooks:
https://blog.aspose.com/2018/07/02/create-manipulate-and-render-slicers-in-ms-excel-files-using-aspose.cells-for-.net-18.6/