Applying AutoFilter to a worksheet RRS feed

  • Question

  • Hi

    I'm generating a very simple Excel sheet with a few columns, texts and numbers. I want the first row, the header to have an AutoFilter. So I added an AutoFilter object with the correct reference ex. A1:E1, but when I open the file it tells me that its damaged. Is there somthing else that needs to be set before I can add autofilter?

    Also when opening the file without adding the auto filter and adding it through Excel 2010, it changes a lot of the cell types etc.

    How you can help me :)


    Wednesday, June 23, 2010 6:54 AM


  • Hi Christian,

    Thanks for your question.

    I suggest you using the Productivity Tool's "Compare Files" to see how to apply AutoFilter to a worksheet. It seems that you need to add elements or properties in the following three aspects:

     <sheetPr filterMode="1"/>

      <row hidden="1" r="2" spans="1:1" x14ac:dyDescent="0.25">

     <autoFilter ref="A1:A4">
      <filterColumn colId="0">
        <filter val="2"/>
        <filter val="3"/>

    Also you could use the Tool's "Validate" function to see what's wrong with your current file.

    Hope this helps.



    • Proposed as answer by Ji.Zhou Wednesday, June 30, 2010 1:30 AM
    • Marked as answer by Ji.Zhou Thursday, July 1, 2010 3:52 AM
    Tuesday, June 29, 2010 9:23 AM