How to keep autofilter when open spreadsheet xml file

Aspose.Cells Product Family
1

When we use Aspose.Cells open function to open spreadsheet xml file and save it as .xls, all autofilter in the original spreadsheet xml file are lost. Is there any way to solve this issue?

Thanks,

2

Hi,

Could you create a test application to show the issue you are mentioning and post us here. It will help us to figure out the issue soon.

Thank you.

3

We find a solution for this issue. After we load the spreadsheet xml file, we use Aspose.Cells.Worksheets.Item(i).AutoFilter.SetRange to re-enable the autofilter.

But for the issue I attached two files in this thread:

excel.xml is the original one which includes the autofilter.

excel.xls is the converted one in which the autofilter is lost.

The code we used is a java script code as following:

var objAspose = new ActiveXObject("Aspose.Cells.Workbook");
objAspose.Open_2("c:\\excel.xml", 7);

objAspose.Save_5("c:\\aspose.xls",3);

4

hi,
we don't find information about autofiter in excel.xml file.
Please try this attached.

thanks.

5

Download excel.rar file, extract file excel.xml, you should be able to find following line of XML:


6

hi,

If you set autofiter in excel.xml file. you must set:

you can set autofiter in excel file and save as excel.xml file by this way.