"Excel found unreadable content" error when opening a spreadsheet with slicers

[Greg Block]

I have a spreadsheet file with slicers. I open this file using XslIO, and populate data in some of the worksheets. Then I save the spreadsheet.

When I try to open the spreadsheet in Excel, I get an error that says, "Excel found unreadable content." I open the spreadsheet file anyway, and the followiung content was removed:



-error064920_01.xml

Errors'>http://schemas.openxmlformats.org/spreadsheetml/2006/main">error064920_01.xml

Errors were detected in file 'C:\sp_work\data\Canada\NominationReport.xlsx'

-Removed Records: Slicer Cache from /xl/slicerCaches/slicerCache1.xml part (Slicer Cache)Removed Records: Slicer Cache from /xl/slicerCaches/slicerCache2.xml part (Slicer Cache)Removed Records: Slicer Cache from /xl/slicerCaches/slicerCache3.xml part (Slicer Cache)Removed Records: Slicer Cache from /xl/slicerCaches/slicerCache4.xml part (Slicer Cache)Removed Records: Drawing from /xl/drawings/drawing1.xml part (Drawing shape)

Aren't slicers supported?

I can't send the file because it has proprietary information.

[Sridhar]

Hi Greg,

Thank you very much for using Syncfusion products.

Currently, In XlsIO we dont have support for slicers in the excel worksheet. We have tried the sample with Pivot Table and Slicers for the Pivot table fields , we could see the clicers are not handled in Essential XlsIO. We have forwarded to the development team for further process and we will get back to you with the details once we hear from them.

Please let us know if you require any further clarifications.

Thanks,
Sridhar.S