Setting a category from segment in .xls download template

Question

We've set up a template to download an .xsl file of entries in a number of specific categories (with much help in this SE thread) - all works fine if we hardcode the category ID but if we tray to make the template dynamic by getting the category ID from the URL segment it fails (see below).

Is it possible to dynamically set the Category ID like this? Or any other way?

{exp:http_header 
    content_disposition="attachment" 
    filename="myfile.xls" 
    content_type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
}
<table>
<tbody>
{exp:channel:entries channel="my channel" category="{segment_3}" disable="category_fields|member_data|pagination"
}
<tr>
<td>{title}</td>
<td>{field_one}</td>
<td>{field_two}</td>
</tr>
{/exp:channel:entries}
</tbody>
</table>

Answer 1

It should work fine. You're just missing a dynamic="no" on your channel:entries tag.

Try it like this:

{exp:channel:entries 
    channel="my channel" 
    category="{segment_3}" 
    disable="category_fields|member_data|pagination" 
    dynamic="no"
}