How to create Slicer in excel 2013 using aspose.cells

Aspose.Cells Product Family
8

Ok, problem was the Aspose.cells version. Using 8.5.2.0, it is working fine.

Thank you.

-Davinder Singh
9

Hi,


Good to know that your issue is sorted out by the latest version/fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.
10

Hi,


I want to save the above excel file in excel binary format (xlsb). For that I am making below 3 changes in the given code-

importFile = CommonHelpers.GetServerPathForTemplate(taxyear, “POC.xlsb”);

wbookName = “POC_test.xlsb”;

CommonHelpers.PrepareWorkBook(ref wbook).Save(this.Response, wbookName, ContentDisposition.Attachment, new OoxmlSaveOptions(SaveFormat.Xlsb));

But I am getting error when i open the saved file. Is there anything else I need to do?

-Davinder Singh
11

Hi,


Thanks for the template file.

After an initial test, I was able to find the issue by using your template POC.xlsx file with our latest version/fix: Aspose.Cells for .NET v8.6.0. I used the following sample code, the output file is not opened fine into MS Excel 2010, Ms Excel prompts “Excel found unreadable content…” error and removes a part of Slicer control:
e.g
Sample code:

Workbook workbook = new Workbook(“e:\test2\POC.xlsx”);
workbook.Save(“e:\test2\out1.xlsb”, SaveFormat.Xlsb);

I have logged a ticket with an id “CELLSNET-43921” for your issue. We will look into your issue to figure it out soon.

Thank you.


12

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-43921 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

Please note we have fixed the issue of corrupted file. But we do not support slicers in xlsb file.


13

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.6.0.1 (attached).

We have fixed the issue of corrupted file but
the slicers are missing as we do not support slicers in the XLSB file format.

Thank you.
14

Hi Amjad,


Infact, after using this version, I found there is no error when opening binary excel file but also I can see the existing slicers are still present in the binary excel file. This is good but I need to confirm if this is expected behavior because your last reply says that even existing slicers will not work in case of binary excel file. I have attached the output binary excel file.

-Davinder
15

Hi,


Thanks for the sample XLSB file.

You are right as I tested as well. The slicers are retained in the template file. You may use the fix and let us know if you find any issue regarding slicers (e.g its functionality or integration with data etc. in the template file in MS Excel). I have also intimated the product team to get complete insight and details on it.

We will get back to you soon.

Thank you.
16

Hi,


Well, slicers are retained in the template file when you open and re-save the Excel file. Please ignore my comment in one of my previous post as we meant the Slicer feature (creating or manipulate Slicers via APIs) is still not supported.

If you find any issue regarding existing slicers in the template file, let us know, we will check it soon.

Thank you.
17

Hi


Is this functionality in the pipeline for release. Would be very useful to have.

Cheers
18

Hi Stephen Jackett,


Well, I am afraid, creating or manipulating Slicers are not supported yet, the feature is also not going to be supported in near future.

We are sorry for any inconvenience caused!
19

Has there been any additional update to create/manipulating slicer in Excel?

20

Hi,

Thanks for your posting and using Aspose.Cells.

We are afraid there is no update for you at this moment regarding this issue. However, we have logged your comment in our database against this issue and requested the product team to provide some fix or ETA for this issue. Once there is some news for you, we will update you asap by posting in this thread.

21

We would like to be able to create / update slicer dynamically too.

22

Hi,

Thanks for your posting and using Aspose.Cells.

This is a new feature which is not yet supported. So we have logged a New Feature request in our database to fulfill your needs.

We will look into it and implement it if possible. Once there is some fix or other news for you, we will update you asap.

This issue has been logged as

  • CELLSNET-44455 - Create or Update Slicer in Excel 2013 using Aspose.Cells

23

The issues you have found earlier (filed as CELLSNET-44455) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

Please also check the document/article for your reference: Install Aspose Cells through NuGet|Documentation

24

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan

25

@davinder_singh_it @Chabie,
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-43921”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

26

@davinder_singh_it, @Chabie,

Please try our latest version/fix: Aspose.Cells for .NET v19.6.2 (attached)

Your issue “CELLSNET-43921” should be fixed in it.

Let us know your feedback.
Aspose.Cells19.6.2 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.6.2 For .Net4.0.Zip (4.9 MB)

27

The issues you have found earlier (filed as CELLSNET-43921) have been fixed in Aspose.Cells for .NET v19.7. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi